software

If I'm using this formula...

=IF(F24=quot;quot;,quot;quot;,F22 F24)

In cell F26and this formula

=IF(F20=quot;quot;,quot;quot;,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: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=532360
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=quot;quot;,quot;quot;,IF(F22 = quot;quot;,0,F22) F24)

Hope this helps.

Martinhomepage.ntlworld.com/martin.rice1/--
mrice
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=532360Hi!

What result do you have in F22?

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

=IF(F24=quot;quot;,quot;quot;,F22 F24)

=IF(FALSE,quot;quot; F24) = #VALUE!

Try this:

=IF(F24=quot;quot;,quot;quot;,SUM(F22,F24))

SUM ignores TEXT entries.

Biff

quot;duuggquot; gt; wrote in
message ...
gt;
gt; If I'm using this formula...
gt;
gt; =IF(F24=quot;quot;,quot;quot;,F22 F24)
gt;
gt; In cell F26
gt;
gt;
gt; and this formula
gt;
gt; =IF(F20=quot;quot;,quot;quot;,F18 F20)
gt;
gt; is in cell F22
gt;
gt; and
gt;
gt; 1
gt;
gt; is in cell F24
gt;
gt; I got a #value! error
gt;
gt; Why is this the case when there is indeed a number 1 in cell F24?
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=532360
gt;