If and then formulas

Guest · Aug 20, 2007

How do I Create a formula like =IF P40>Q38 then G44=X if P40<Q38 G44=","

Guest · Aug 20, 2007

Put this in G44

=IF(P40>Q38,"X",",")

Mike

Guest · Aug 20, 2007

My last formula was wrong, try this instead.

=IF(P40>Q38,"X",IF(P40<Q38,",","Unspecified"))

Mike