Hi,

Having an issue with an IF statement. I'm running the formula in
column G (blank column). What I want it to do is read column F, if the
number 21010009 is in there I then want it to read column U, if there is
an F in there I want it to return the number 21060201 in Column G.

I tried a couple of different combinations like this:
=If(F2=21010009,U2=F), 21060201). None of my combos so far have pulled
in what I want. Any ideas?


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566

=If(and(F2=21010009,U2=F), 21060201,"")

Vaya con Dios,
Chuck, CABGx3



"punter" wrote:


Hi,

Having an issue with an IF statement. I'm running the formula in
column G (blank column). What I want it to do is read column F, if the
number 21010009 is in there I then want it to read column U, if there is
an F in there I want it to return the number 21060201 in Column G.

I tried a couple of different combinations like this:
=If(F2=21010009,U2=F), 21060201). None of my combos so far have pulled
in what I want. Any ideas?


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566

Hi Punter,

try

=If(F2=21010009,U2="F"), 21060201)

So if the 21010009 and 21060201 are also a text put " before and after of them

hope this helps
regards from Brazil - goingo the 6th *
Marcelo


"punter" escreveu:


Hi,

Having an issue with an IF statement. I'm running the formula in
column G (blank column). What I want it to do is read column F, if the
number 21010009 is in there I then want it to read column U, if there is
an F in there I want it to return the number 21060201 in Column G.

I tried a couple of different combinations like this:
=If(F2=21010009,U2=F), 21060201). None of my combos so far have pulled
in what I want. Any ideas?


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566

sorry I forgot the and so

=If(and(F2=21010009,U2="F"),21060201;"")

regards

"Marcelo" escreveu:

Hi Punter,

try

=If(F2=21010009,U2="F"), 21060201)

So if the 21010009 and 21060201 are also a text put " before and after of them

hope this helps
regards from Brazil - goingo the 6th *
Marcelo


"punter" escreveu:


Hi,

Having an issue with an IF statement. I'm running the formula in
column G (blank column). What I want it to do is read column F, if the
number 21010009 is in there I then want it to read column U, if there is
an F in there I want it to return the number 21060201 in Column G.

I tried a couple of different combinations like this:
=If(F2=21010009,U2=F), 21060201). None of my combos so far have pulled
in what I want. Any ideas?


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566

Sorry, as Marcello, I also forgot something.........

=If(and(F2=21010009,U2="F"), 21060201,"")

Coffee........need more coffee <g

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

=If(and(F2=21010009,U2=F), 21060201,"")

Vaya con Dios,
Chuck, CABGx3



"punter" wrote:


Hi,

Having an issue with an IF statement. I'm running the formula in
column G (blank column). What I want it to do is read column F, if the
number 21010009 is in there I then want it to read column U, if there is
an F in there I want it to return the number 21060201 in Column G.

I tried a couple of different combinations like this:
=If(F2=21010009,U2=F), 21060201). None of my combos so far have pulled
in what I want. Any ideas?


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566

Thanks guys. That worked great.

Eddie.


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566

You're welcome Eddie..........thanks for the feedback

Vaya con Dios,
Chuck, CABGx3



"punter" wrote:


Thanks guys. That worked great.

Eddie.


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566