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?