# Dividing Numbers Evenly

Apr 6, 2009
I have a total at the bottom of my spreadsheet and I want to distribute that total equaly to the missing columns for each month and each product highlighted in green in the spreadsheet. What formula do I need to use to be able to do that?

At the end I want the numbers in each month to total the total at the bottom.

View 10 Replies
ADVERTISEMENT
Aug 27, 2012

How to increase & decrease numbers evenly for a spreadsheet.

I have a number in cell F16 that can be changed and for this example say it has a value of 900.

I have a number in cell F17 that is always more than cell F16, for this example lets say it is 1000.

What I'm trying to do is create 10 numbers evenly increasing away from 900 (F16) in value, & 10 numbers evenly decreasing in value away from 900 (Cell F16) but here's the catch.

What makes this tricky is that the numbers that are increasing in value away from 900 (F16) can't be bigger than the value of F17 , IE in this example the number 1000

So the formulas must evenly distribute 10 numbers BETWEEN 900 & 1000. This must have the same even distribution for the increasing numbers & decreasing numbers.

I'll attach a sheet also. So, if you say 900 is a starting point & 1000 is the ending point, what formulas would you need in each cell to evenly increase to 1000?

Also,, going the other way, decreasing, away from 900 at the same rate as the increase?

Really stuck n this 1.

Spreadsheet here: [URL] ......

Screenshot here: [URL] ......

I'll attach a spreadsheet .xls

View 5 Replies
View Related
Sep 6, 2006

I've found how to present time exceeding a minute in seconds ([m]:ss.00), but I need to formulate items per second. Doing simply CellItem / CellTime won't work. I've tried Minute(CellTime)*60+Second(CellTime), but this leaves out the hundreds of a second.

View 3 Replies
View Related
Jan 25, 2009

A given string of some letters (from three to five, six) is followed by a single number (1-4). Then it ends, or is followed by another such combination, up to a maximum of, let's say, four.

Example:

xxxx1

yyy3yyyy1

xyzxx1yxz4xzx1

xxx2xxx2xxx2xxx2

What I would like to do is to divide a given chain of characters into the smallest chains which contain only letters and one number. To the examples given above, I'd like to receive the following sets:

xxxx1

yyy3 and yyyy1

xyzxx1 and yxz4 and xzx1

... and so on

Is it somehow possible to do it with simple functions? Or is VB necessary (which sadly I don't know)?

View 6 Replies
View Related
Dec 11, 2009

Does anybody know the code or the formula to divide a number generated by a formula. Id like to divide this number by 2 different set numbers. Meaning if my number comes out ot 19, id like to divide this by 5.5 and if it's not a whole number which this isn't (it's 3.45), i'd like to round this number to a whole number and add 2.5. My end answer would be 3 5.5 and 1 2.5.

Windows XP

Excel 2003

View 9 Replies
View Related
Mar 21, 2013

I'm trying to work out the productivity of something per hour but I'm having a bit of trouble with dividing time in Excel.

Basically I've got

A1 = # of Sales (e.g. 5)

A2 = Total time worked (e.g 07:36:00)

I want C1 to show me how many Sales are made per hour.

View 1 Replies
View Related
Dec 19, 2006

I have a txt file imported into excel that's slightly strange.

But once into excel, I need to edit some numbers.

The values in cell B 23 is 1.

So is the value in B 28, so is the value in B 33, B38, B 43 and so forth ad infinitum... Or so it feels.

I need to edit all those values to 0.

View 9 Replies
View Related
Feb 13, 2012

I am using excel 2007 or 2010.

I need to divide the numbers on sheet 1 column D. This column contains numbers and blank cells so I need to divide by the actual number of cells that contain only numbers. I will be referencing the divided numbers on sheet 2 in a monthly summary format.

View 3 Replies
View Related
Dec 10, 2009

I have dollar amounts that I need to distribute amongst varying numbers of columns and not have have the total distributed be over or under the original amount by any number of cents. When I simply divide the dollar amount by the number of columns, the total of those columns can sometimes be more or less than the original dollar amount by a few cents.

e.g.

Dollar # of A B C All Columns

Amount Columns Total

--------------------------------------------------------------------

$25.05 2 $12.53 $12.53 $25.06

$11.47 3 $ 3.82 $ 3.82 $ 3.82 $11.46

$25.05 divided into 2 columns gives $12.53 in Column A and $12.53 in Column B. Total of Columns A and B is $25.06. Over by a penny.

$11.47 divided into 3 columns gives $3.82 in Columns A through C. Total of Columns A through C is $41.46. Under by a penny.

I know I could simply always add or take away the pennies from one column, but I would prefer the process to be random or formulated in such a way that the Column to which the extra pennies are added to or taken away from differs in order to be "fair to each column".

View 10 Replies
View Related
Sep 22, 2009

I have a column of numbers in cell A1 through A10.

In cell A11 I would like to count how many times the numbers listed from A1 through A10 are evenly divisible by 5.

How would I do this?

View 10 Replies
View Related
Aug 14, 2013

When we sell things here at a 'sale' price there is always an argument as to who's department needs to give the discount off.

Each job we do has a labour time and an hourly labour rate.

Each part has a profit in it.

So if something is normally £100 but we are going so sell it for £80 we need tio split the £20 reduction evenly to both departments based on the GP each department has in the sale.

See attached : GP Reduction per department.xlsx

View 4 Replies
View Related
Sep 10, 2013

I'm working on a project that will will have varying tasks & estimating the total duration to complete these tasks.

For example:

If estimating that the min-project will take 90 days & I have 17 tasks, how can I distribute the 90 days evenly amongst the 17 tasks?

View 5 Replies
View Related
May 22, 2014

I need a formula to do two things I need it to look at Cell C2 and if it does not contain a number then I want the letter A put in the cell, if it contains a number then if that number is divisible by five giving a whole number i.e like 10,15 20 would, then input 1, but if not 2.

View 1 Replies
View Related
Sep 28, 2009

I don't know how else to ask this so I will just tell you what I'm trying to do.

-I have a list of name on one column say "A"

and this list of names goes through "A1" through "A145"

-I am taking those names and pasting them via "right click" "paste special"

"Values" onto another spreadsheet.

-BUT I have to take each name one by one and paste them evenly

in every 8th row for example ( "A1" A8" "A16" "A24" ...)

-Is there a way to take the existing data on that row and just spread it evenly throughout the same row? So I don't have to take names one by one by one...

View 9 Replies
View Related
Dec 9, 2006

I am currently tracking our company's service tasks in Excel and would like a formula or method that will take the total hours a task has been approved for and equally distribute the hours into columns under each month.

Column A = Resource

Column B = Task Owner

Column C = Task Name

Column D = Task Description

Column E = Approved Hours

Column F = Start Date

Column G = End Date

Column H = Jan 07

Column I = Feb 07

Column J = March 07 etc. etc.

I basically want to take the approved hours (Column E) and have those hours automatically calculated and filled into the month columns (Column H forward), as per the start and end date fields (Column F & G) so the hours are evenly distributed over each month.

View 9 Replies
View Related
Dec 28, 2013

I am using a staff schedule spreadsheet and have each column displaying text of where a staff person is assigned.

Instead of displaying the word "lunch" separately across several columns, is it possible to merge several columns and have the word "lunch" automatically stretched evenly across the several merged columns?

I dont want it to be centered but to literally be stretched to fit evenly across all of the merged cells.

View 4 Replies
View Related
Jan 29, 2009

Need to divide a cell containing a time value (hrs:mins:secs). My timesheets calculates the number of hours on a job and I want to divide this total by the number of components made.

View 7 Replies
View Related
Jun 24, 2014

How to do the following?

When dividing two cells and the answer is zero then I want to return a different value. I've tried the following with no luck:

=IF(ISERR($D20),"*",$G20/$G$22*100)

or

=IF($H19,$G19/$G$22*100,"-")

=if a1/b1 = 0 then "*", else return actual value

(N)(%)

64 13

82 16

82 16

2 0 --> change this to * or -

264 52

13 3

507(total)

View 9 Replies
View Related
Dec 9, 2008

I am trying to distribute a list of data evenly throughout the list of people I have.

I am not sure how to describe it so I will upload the example excel as an attachment.

View 7 Replies
View Related
Sep 15, 2014

Dividing column in equal parts divide a column in groups with the same rows and the same total sum? For example, I have the column A as following:

8,942

2,807

2,568

5,818

5,818

596

8,942

4,390

1,607

890

8,772

1,103

The total number of rows is 12 and total amount is 52,254

I want to divide the column in three equal parts with the same total. So each group must contain 4 rows with the total sum 17,418

View 9 Replies
View Related
May 23, 2006

Have a list of information and would like to divide that list by a number that the user enters. Then from the total count of nonblank rows divide by the numeber entered by the user didive the list into equal parts and print out each group with a page break per groups.

Have attached an example.

View 6 Replies
View Related
Jul 26, 2014

V = 100 x [E /(IY + YP)] x Sqr. [((R + G)/2 / (IY + YP + F)]

V = 100 x [6.10 /(5.60)] x Sqr. [((10.2+2)/2 / (5.60 + 2.1]

V = 108.93 x Sqr (.79)

V = $96.89 / share as of 7/18/2014

E = Earnings in $ / share 6.1 (b9)

IY = Interest rate in % 5.6 (b10)

R = Profitability Factor in % (internal growth rate)10.2 (b11)

G = Earnings Growth in % / yr. 2 (b12)

F = Inflation Rate in % / yr. 2.1 (b13)

Here's what I have, result should be $96.89, I need to tell excel to take square root of everything to the right not just (B11+ B12)

=100*(+B9/B10)*SQRT(B11+B12)/2/(B10+B13)

View 3 Replies
View Related
Jan 24, 2014

I'm not sure if it's just been a long week but I can't get get the following to work in a sum formula.

In the example below I want to deduct B1 from A1 and then Divide by C1. The result should be 0.57 but I can't get to it within 1 formula.

9:49:12 - 6:18:46 = 3:30:26 / 2 = 0.57!!! Not sure if it's because I'm using unfriendly hh:mm:ss format but I need to.

A1 - 9:49:12

B1 - 6:18:46

C1 - 2

View 5 Replies
View Related
Feb 10, 2014

Cell A1 contains 2, B1=220077:23

In C1 I created a function = (2*1000)/B1, I get error. I want the answer 2000/220077h23m = 0.009087713

View 5 Replies
View Related
Nov 5, 2008

how could divide one single cell in diagonal direction ?? without using line from drawing tool.

View 12 Replies
View Related
Apr 9, 2009

I am trying to divide a range that has blanks in. The range is the result of a webquery and taking the blanks out would be time consuming at best.

Conveniently (potentially) the blank row is every other row in the range.

View 4 Replies
View Related
Mar 13, 2013

I am attempting to calculate % utilization. I have number of minutes used formatted in [mm]:ss and number of minutes available formatted as a number. When I divide available by minutes used I get a percentage that is off.

So I have Available 33600 minutes available 4901:20 minutes used.

View 2 Replies
View Related
May 23, 2007

Suppose I have the following plan number (24) and I wan't to spread it across 12 columns, as evenly as possible but with respect to rounding.

Easy enough.. Each column receives 2...

Or say the figure was 24.6 and i wanted to round to 2 places...

Easy enough... Each column receives 2.05...

Or say the figure was 24.7 and i wanted to round to 2 places...

Easy enough... Each column receives 2.05... But one would be 2.06!

How about the number is 1 and say, the rounding is 0.1?

Ten of the columns would be .1 while two others (arbitrarily) would be 0.

View 9 Replies
View Related
Apr 15, 2009

In trying to solve my dilema I searched some older threads and found some code written by Peter SSs. I altered it to fit my situation ( or so I thought) because all I get is a compile error. I am not sure why. The data is lengnty but the sorting item is the provider name. The information for each provider should then post to the sheet with his name.

Here is the

Sub test()

Dim lr As Long

Dim ws As Worksheet

Application.EnableEvents = False

Application.ScreenUpdating = False

lr = Sheets("Audit Results").Range("F" & Rows.Count).End(xlUp).Row

For Each ws In ThisWorkbook.Worksheets

View 11 Replies
View Related
May 23, 2006

Have a list of information and would like to divide that list by a number that the user enters. Then from the total count of nonblank rows divide by the numeber entered by the user didive the list into equal parts and print out each group with a page break per groups. Have attached an example.

View 4 Replies
View Related