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

"Kevin B" wrote:

Try the following:

=IF(ISBLANK(E6),"",E6)
--
Kevin Backmann


"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