#VALUE using IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the following

In cell F3: =IF(E3>0,E3-E2,""

In cell E3: =IF(B3>0,SUM(B3:D3),""

Cells B3 to D3 are entered value

When there are no entries in B3:D3, I get the #VALUE error in cell F3, even though cell E3 is empty(only a formula in it). Is there any way to use IF only for values

Thanks!
 
One way:

=IF(E3<>"",E3-E2,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Using the following:

In cell F3: =IF(E3>0,E3-E2,"")

In cell E3: =IF(B3>0,SUM(B3:D3),"")

Cells B3 to D3 are entered values

When there are no entries in B3:D3, I get the #VALUE error in cell F3, even
though cell E3 is empty(only a formula in it). Is there any way to use IF
only for values?

Thanks!
 
You are getting an error message in F3 when there is no
value in B3 because the formula in E3 says to return the
value "" if the value in B3 isn't >0. And "" isn't a
number, when F3 looks up in E3, it finds nothing meeting
the parameters specified, so you get an error message.
Replace the "" with a 0 (zero) and you should be fine.
 
Back
Top