HI Lori
Try removing your double quotes around the numbers
e.g.=IF(Y2=1,1099.23,IF(Y2=2,824.42, IF(Y2=3,100.00))

HTH
John
"Lori" wrote in message
...
I have a column with the following formula in each cell. The formula
calculates correctly, but when I try to autosum or even enter =sum(z1.z100)
it keeps returning a 0 value.
=IF(Y2=1,"1099.23",IF(Y2=2,"824.42", IF(Y2=3,"100.00")))

I have about 1800 lines to add! Any suggestions?
Thanks!