ExcelBanter - If and then formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If and then formulas (https://www.excelbanter.com/excel-discussion-misc-queries/154932-if-then-formulas.html)

fyrefox

If and then formulas

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

Mike H

If and then formulas

Put this in G44

=IF(P40Q38,"X",",")

Mike
"fyrefox" wrote:

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

Mike H

If and then formulas

My last formula was wrong, try this instead.

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

Mike

"fyrefox" wrote:

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

All times are GMT +1. The time now is 02:57 PM.