Different day, different IF issue

P

punter

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

Marcelo

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

Marcelo

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:
Click to expand...
 
C

CLR

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 said:
=If(and(F2=21010009,U2=F), 21060201,"")

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Top