If and then formulas

[fyrefox]

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

 

[Mike H]

Put this in G44

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

Mike

 

[Mike H]

My last formula was wrong, try this instead.

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

Mike