Creating formula in smartsheet

Jasmine Hassan
Jasmine Hassan ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

I have a requirement to create the below formula in smartsheet. Please help.

If short shelf life is between 40% to 59%, then discount is 5% on the invoiced amount,

If short shelf life is between 30%– 39%, then discount is 15% on the invoiced amount,

If short shelf life is between 20 – 29%, then discount is 40% on the invoiced amount,

If short shelf life is 19% & below, then discount is 50% on the invoiced amount 

Thanks,

Jasmine

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!