Thread: replace a cost

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.

Couple of ways. First is to use =IF(B5>10,M5,50) in G, but that would require replacing 50 with the real value in every row. A better way would be to copy and paste G into L, and then use =IF(B5>10,L5,M5) in G. That could be copied down as needed, provided your price change always occurs at 10.

Thanks Darkyam,

I used the better way you suggested and that has worked perfectly.

Very much appreciated.

Job done!