User Profile
MichelleAten
Copper Contributor
Joined Dec 08, 2021
User Widgets
Recent Discussions
Need help with writing the correct formula
Currently using a PC with Windows 10 and the Excel versions is 16051.14527.20276.0 I am creating a price list for materials used on service call jobs and I need to show our cost and the price including the markup. The markup amount depends on the cost of the item. Specifically: If the item costs $10.00 or less the cost is doubled so it is multiplied by 2 If the item costs $10.01 to $100.00 the cost is multiplied by 1.6 If the item costs over $100.00 then the cost is multiplied by 1.7 I already have pages and pages of parts and their costs. If a formula exists to calculate my prices, it would be a HUGE help to just add a column with such a formula to get the all the marked up prices at once. If not, I will have to calculate each item one at a time. If this is not the right forum to ask this question, I apologize and would appreciate direction on where I should post. Otherwise any help with this is greatly appreciated. Thank you, MichelleSolved1.2KViews0likes3Comments
Recent Blog Articles
No content to show