Creating a formula to determine cost based on different factors

alex_hacker

Hello!

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

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!