On Feb 16, 9:43*pm, abusymomforever
wrote:
I have tried every fx, combination of functions, formulas, etc and nothing
seems to work. *Here is what I have and please someone tell me how to get a
numeric sum that isn't 0! Column B is IF Statement copied down Column B
=IF(a8=1234,"268.80",IF(a8=2345,"335.80",IF(a8="N/A","0.00",IF(a8=9876,"230.00",IF(a8=1010,"245.00", "0.00")))))

A * * * * * * * * * * * * *B * * * * * * * * * *
8 * *1234 * * * * * * * 268.80
9 * *2345 * * * * * * * 335.80
9 * *N/A * * * * * * * * * *0.00
10 *9876 * * * * * * * 230.00
11 *N/A * * * * * * * * * *0.00
12 *1010 * * * * * * * 245.00

Even with the correct number of (), changing the N/A to 0 and changing it in
the formula I still get 0 or #value or some other error message. *I did try
sum(a8+a9) and that seemed to work but I have hundreds of cells to add and
that just won't be feasible.

Please HELP!!!!

abusymomforever

You don't need quotes in the formula,
=IF(A1=1234,268.8,IF(A1=2345,335.8,IF(A1="N/A",0,IF(A1=9876,230,IF
(A1=1010,245,0)))))
Using quotes makes the nubers text