Calculating Mileage rate

joelsmit94161 ✭✭✭✭
edited 02/13/23 in Formulas and Functions

I am trying to calculate mileage based on two numbers. $.655 for 500 miles or less and $.3275 for 501 miles or more.

=IF([Total Mileage]@row <=500, [Total Mileage]*0.655, IF([Total Mileage]@row [Total Mileage]@row*0.3275))

This does not seem to be it.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!