# Calculation Formula /commission calculation

Options
✭✭✭✭

I Need to create formula in Commission column as follow :

If amount in Price Col has amount equal to 20.00 or less Than to input the amount 2.00 in commission col

and if the amount is between 21.00 to 25.00 than to input amount 3.00 in commission col

and if amount is between 26.00 to 30.00 than to input the amount 4.00 in commission col

and if amount is equal to 30.00 and higher than to put the amount 5.00 in commission col

Thank you

Tags:

• ✭✭✭✭✭
edited 01/28/23
Options

This should work

=IF([Price]@row>=30, 5, IF([Price]@row>=26, 4, IF([Price]@row>=21, 3, 2)))

Started at 30 and worked my way down..

this will give anything under 20 a \$2.00 commission

This would give zero commission for <0

=IF([Price]@row>=30, 5, IF([Price]@row>=26, 4, IF([Price]@row>=21, 3, IF([Price]@row>=0, 2, 0))))

Brent C. Wilson, P.Eng, PMP, Prince2

Facilityy Professional Services Inc.

http://www.facilityy.com

• ✭✭✭✭
Options

It work exactly as we want , so many thanks

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!