Hi
I have created an excel spreadsheet to calculate the cost of repairs. But…. if the qty going for repair is more than say 10 items the cost goes down.
Can anyone help with a formula that will detect that the qty is more than 10 and insert the cheaper price?
In the example attached example, if B5 is more than 10 I want the price from M5 to replace the price in G5 so it then calculates the cheaper cost in J5.
Could that work or is there a better way?
Much appreciated if anyone can help. Driving me bonkers.
Bookmarks