Hi,

If for any reason you don't want to remove "" around number then you can
change your formula to

=--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")))))

Personally, I think you should be using VLOOKUP for the calculation, with or
without "".

Quotes makes number text and text doesn't add up.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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