IF formula with division of cells
Options
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
Answers

Try this:
IF(AND([Column2]@row = "yes", [Column3]@row <> ""), ([Column4]@row / [Column5]@row), "check later")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!