"False"

K

Keyrookie

How do you remove the "FALSE" value in a cell. The formula I'm using i
simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have
"p".

Help please,

Keyrooki
 
P

Peo Sjoblom

So what do you want it to return? Blank?

=IF(I7="p",G7,"")


--


Regards,


Peo Sjoblom
 
D

Dave Peterson

=if(i7="p",g7,"whatdoyouwantinstead")
or
=if(i7="p",g7,"")
to make it look blank
 
Top