That old #VALUE! problem

[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

 

[sybmathics]

What exactly is your formula?
If you don't show us the formula that creates the problem we can't identify
the problem,

Anyone in tis group is willing to help.

Greets,

Sybolt

 

[Zack Barresse]

Hi Nick,

Have you tried the formula auditor to find the source of the error?
Generally that error is from trying to sum text.

 

[Pete_UK]

I suspect you have something like this in your IF statements:

=IF(condition,"1","0")

Although this will look as if you are returning numbers to the cells,
they are in fact text values. If you then try to carry out some
arithmetic on them the arithmetic function will return #VALUE.

Hope this helps.

Pete

 

[Nick Wakeham]

Thank you - that is a huge help and has explained a lot!

Many thanks

Nick