Formula error, don't understand why...

[duugg]

If I'm using this formula...

=IF(F24="","",F22+F24)

In cell F26


and this formula

=IF(F20="","",F18+F20)

is in cell F22

and

1

is in cell F24

I got a #value! error

Why is this the case when there is indeed a number 1 in cell F24?

 

[mrice]

The problem appears to be that when you have a 1 in F24, you are
attempting to add a string (in F22) to a number (in F24).

You can get around this problem with the following formula in F26

=IF(F24="","",IF(F22 = "",0,F22)+F24)

Hope this helps.

Martin


http://homepage.ntlworld.com/martin.rice1/

 

[Biff]

Hi!

What result do you have in F22?

If the formula in F22 returns "" then you'll get the #VALUE! error because
you're attempting to perform math on a TEXT value. The "" is a zero length
TEXT string. So:

=IF(F24="","",F22+F24)

=IF(FALSE,""+F24) = #VALUE!

Try this:

=IF(F24="","",SUM(F22,F24))

SUM ignores TEXT entries.

Biff