"False"

  • Thread starter Thread starter Keyrookie
  • Start date Start date
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
 
=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

FALSE value 3
nested if statements using "AND" as well as "OR" 2
find text in a string formula 5
Custom Validation formula for business rules 3
The "IF" Statement 1
IF Statement 1
And function into If function 4
If any 3 of 5 values are 0 then 0. 8

Back
Top