IF formula with division of cells

GabyC

Hello,

I keep getting an error with my IF formula. I want it to read:

IF this cell says "Yes" and this cell is not blank, divide contract costs by total project cost

Seems easy enough but it is giving me errors.

Thank you

Gabby Mihova

Try this:

IF(AND([Column2]@row = "yes", [Column3]@row <> ""), ([Column4]@row / [Column5]@row), "check later")