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

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)
--
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
>

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?

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

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

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

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

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

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

Peter

"Jenna" <[email protected]> wrote in message
news:[email protected]...

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

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


"Peter1999" wrote:

>
> =IF(ISBLANK(E6),"Not Given",E6)
>
> If you have another column where a phone number might be you could
> write:
>
> =IF(ISBLANK(E6),IF(ISBLANK(F6),"Not Given",F6),E6)
>
> Where F6 represents the cell where you might or might not have a phone
> number.
>
> Peter
>
>
> --
> Peter1999
> ------------------------------------------------------------------------
> Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997
> View this thread: http://www.excelforum.com/showthread...hreadid=549045
>
>