Creating a formula to determine cost based on different factors
Hello!
I am trying to find a formula. Basically, in column A I have a number (example1500) 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 01500...multiple by 5. If the number in Column A is 15012000, multiple by 10.
Can anyone guide me in the right direction?
Tags:
Answers

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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!