IF OR formula?

[Marq]

I want to add to this formula:

=IF($D$6="Yes","x","")

I want it to say if D6 = "Yes OR if it equals "Pending" then populate the cell with an "x"

I tried =IF($D$6="Yes","x",""),IF($D$6="PENDING","x","")).....but it did not work..what am i doing wrong?

 

[Fluff]

How about

=IF(OR($D$6={"Yes","Pending"}),"x","")

 

[aghaffar82]

Try this
=IF(OR($D$6="Yes",$D$6="Pending"),"x","")

 

[Dave Patton]

T202011b.xlsm
	D	E	F
1
2	Yes	x	x
3
2e

Cell Formulas
Range	Formula
E2	E2	=IF(OR(D2={"yes","pending"}),"x","")
F2	F2	=IF(OR(D2="yes",D2="pending"),"x","")

 

[Marq]

Try this
=IF(OR($D$6="Yes",$D$6="Pending"),"x","")

that works..thanks!

 

[aghaffar82]

that works..thanks!

Great, thank you for the feedback!