IF Formula to give me a $ amount when criteria's are met
I am working on a calculation model for my company and essentially I am looking for Smartsheet to give me the following information.
I currently have the formula for the first part figured out, I need help with the 2nd part.
If the "Quantity is <= 10 the amount should come out to $13,500.00
I need this formula to multiply the "$13,500.00" by (2) if the Quantity is between 11 and 20. My current formula that is working for the first step is below:
=IF([Equipment Quantity]@row <= 10, [Column4]@row)
Help Article Resources
Check out the Formula Handbook template!