"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
 
S

Sandy Mann

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


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
FALSE value 3
Change a great number of words in word files, with a macro as short as possible. 5
Word macro that can call cells out of Excel for a find and replace 0
nested if statements using "AND" as well as "OR" 3
Custom Validation formula for business rules 3
Finding identical rows in a list 6
And function into If function 4

Top