Can a value from a different cell be the false answer in =If q
"Jenna" wrote in message
...
"Kevin B" wrote:
"Jenna" wrote:
I want to write an If statement where if the answer is false, the exact
value
from another cell will go into the cell with the formula.
For example.
In H6 i would write
=If(E6=not given, "", "E6")
where if E6 = not given nothing would appear in H6, but if it did NOT =
not
given then the value in E6 would go into H6
Try the following:
=IF(ISBLANK(E6),"",E6)
Sorry, I should have been more clear.
E6 will actually say "Not Given" or have a phone number in it. It will
not
be blank if nothing is given.
Is there a way to do this?
=IF(E6="Not Given","", E6)
--
David Biddulph
|