Formula error, don't understand why...
 

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?


--
duugg
------------------------------------------------------------------------
duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=532360

Formula error, don't understand why...
 

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/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532360

Formula error, don't understand why...
 

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

"duugg" wrote in
message ...

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?


--
duugg
------------------------------------------------------------------------
duugg's Profile:
http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=532360