Is it possible to use “IF” to select which Formula to use in a cell?


Calculate different % based on value in Column A

The concept:

  • Column A is either 0 or 1
  • Column B is the base value
  • Column C is the Result

 If Column A = 1


Column C= Column B *0.86


Column C= Column B *0.80

    End IF


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!