| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only a genius can help with this 7 Nested If that doesn't fill down
I'm using MS XL 2000 App.Range("AQ2").Formula = "=IF(AT2 = 500,MROUND(AI2,500),IF(AT2 = 5,MROUND(AI2,5),IF(AT2=10,MROUND(AI2,10),IF(AT2 = 25,MROUND(AI2,25),IF(AT2 = 100,MROUND(AI2,100),IF(AT2 = 200,MROUND(AI2,200),IF(AT2 = 364,MROUND(AI2,364),ROUNDDOWN(AI2,0))))))))" App.Range("AQ2:AQ" + Total).FillDown 'where TOTAL = record count of a query I get #Name# in the cells that I want to be calculated. My formula doesn't fill correctly. I've tried switching the automatic and manual and iteration and calculate before saving and they do not work. I've also tried formatting the number. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| jack nicolson - genius!!! | Excel Discussion (Misc queries) | |||
| Formula needed help from a genius!!! | Excel Discussion (Misc queries) | |||
| genius wanted VBS | Excel Discussion (Misc queries) | |||
| Question for all the excel Genius | Excel Discussion (Misc queries) | |||
| Excel Genius Required! | Excel Discussion (Misc queries) | |||
Threaded Mode
