IF formula with division of cells



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!