| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DIVIDE NUMBERS EVENLY
Put this formula in B1:
=ROUND($A1/6,2) and copy to cells C1:F1. Put this formula in G1: =A1-SUM(B1:F1) I'm not sure where H1 comes into it. Hope this helps. Pete NEYS wrote: I have a worksheet with data. I need to be able to divide a number evenly between 6 different cells. ie: A1=349.97 then B1 thru F1 should read 58.33 but since the numbers do not divide evenly I need G1 to read 58.32. I also need H1 to read 0.00 or blank. Please, please, please I need help I have been trying to figure it out on my own for the past few days!!! Thank You, -- NEYSA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Divide numbers and distribute evenly. | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Threaded Mode
