Formula

[j4ymf]

Hello
Sorry by XL2BB is not working

could you please help me write a formula, im looking to lookup if column C has Working Through Grid - 60 min or Working Through Grid - 30 min
Then colulm M would be the total cost / 1.5

M6= P6 if C6 = Working Through Grid - 60 min or Working Through Grid - 30 min / 1.5
M7= P7 if C7 = 60 min or 30 min / 1.0

Hope this helps
Thank you

 

[Fluff]

I have no idea what you are trying to say, but this is now a significantly different question & so needs a new thread. Thanks