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

     Then

Column C= Column B *0.86

     Else

Column C= Column B *0.80

    End IF

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!