bullethvac
New Member
- Joined
- Jan 10, 2023
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi,
I need help with a formula if possible. I have a spreadsheet that I use to price products for construction bidding purposes. My parts have different markups dependent on their cost. Is there a formula that can automatically change the markup calculation based on the ranges of the cost?
example: if I were to enter $30.00 in C3, I would want C5 to show a markup of 3.5 and C7 to show the sell price of $105.00
if I were to enter $255.00 in C3, I would want C5 to show a markup of 2.0 and C7 to show the sell price of $510.00
etc.
Thank you in advance!
I need help with a formula if possible. I have a spreadsheet that I use to price products for construction bidding purposes. My parts have different markups dependent on their cost. Is there a formula that can automatically change the markup calculation based on the ranges of the cost?
example: if I were to enter $30.00 in C3, I would want C5 to show a markup of 3.5 and C7 to show the sell price of $105.00
if I were to enter $255.00 in C3, I would want C5 to show a markup of 2.0 and C7 to show the sell price of $510.00
etc.
Thank you in advance!