That Old #VALUE! problem

N

Nick Wakeham

I have made up a spreadsheet that has lots of cells with IF formulas but I
want the result of those cells to add up as a total. However, no matter how
I try, the total cell keeps coming out with the dreaded #VALUE!.

All the IF formulas are fine and work well but I need them all to add up but
show nothing in the cell unless there is a value worked out in the original
IF cells.

Hope that's clear and that someone can help.

I am using OFFICE2000.

Nick
 
P

Peo Sjoblom

The value error derives from calculating text so in your if formulas you
might have included either "" or "5" as an example. Also when totaling if
you use SUM(A1,A3 etc) or =SUM(B1:B10) they will ignore text and only sum
the numerical values. OTOH =A1+A3 as an example will cause an error if a
cell included in the calculation is text


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top