Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - should this be a macro?
Hi all,
I am trying to divide 1 number between several cells. Check the value and verify the sum of those cells is the same as the beginning number. my formula is as follows: [Cell D22] =IF(N22<0,ROUND(C22/N22,0)) [Cell E22] =IF(N221,ROUND(C22/N22,0),0) [Cell F22] =IF(N222,ROUND(C22/N22,0),0) [Cell G22] =IF(N223,ROUND(C22/N22,0),0) [Cell H22] =IF(N224,ROUND(C22/N22,0),0) [Cell I22] =IF(N225,ROUND(C22/N22,0),0) [Cell N22] =ROUNDDOWN(C22/10,0) It's close to what I need, but not right yet. Please help. Byron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
How do I set up a formula with a changing range in an excel macro | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |