Creating a formula to determine cost based on different factors


I am trying to find a formula. Basically, in column A I have a number (example-1500) and I am looking to find a formula that will calculate the cost based on range.

I.E. if the number in Column A is 0-1500...multiple by 5. If the number in Column A is 1501-2000, multiple by 10.

Can anyone guide me in the right direction?



  • ker9
    ker9 ✭✭✭✭✭✭

    Hi @alex_hacker

    See if this will work for you:

    =IF([Column Name]@row < 1501, [Column Name]@row * 5, IF([Column Name]@row < 2001, [Column Name]@row * 10))

    Replace "Column Name" with the name of your column.

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!