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)
Answers

@Drew.Paice Can you list the name of the columns (or provide a screenshot) and all the things your formula is trying to do? For example
 If quantity is between 11 and 20, multiply $13,500.00 by 2 (why would you need to multiply by 2 instead of just having $27,000.00?)
 (I'm assuming based off your formula) if quantity is 10 or less, equal Column4
 What about quantities over 20?

Column 1 = Phase
Column 2 = Equipment
Column 3 = Equipment Quantity
Column 4 = Price
Column 5 = Total Price
For the purpose of the sheet I am trying to create, anything more than 20 would be handled separately off of Smartsheet.
I would have no issue with it not multiplying by 2 and it simply giving me the $27,000.00 amount, I am just having issues with the formula spitting that information out for me.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 283 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!