Can a value from a different cell be the false answer in =If quest

J

Jenna

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
 
J

Jenna

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?
 
J

Jenna

Sorr, I shoul dhave been more clear.

E6 will actually say "not given" or have a phone number in it. It will not
be blank.

thanks
 
P

Peter1999

=IF(ISBLANK(E6),"Not Given",E6)

If you have another column where a phone number might be you coul
write:

=IF(ISBLANK(E6),IF(ISBLANK(F6),"Not Given",F6),E6)

Where F6 represents the cell where you might or might not have a phon
number.

Pete
 
J

Jenna

But E6 won't be blank. it will either have a phone number in it or say "not
given"
 

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

Top