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

 

[SanjayGMusafir]

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

Check this -

=IFS(OR(C6="Working Through Grid - 60 min",C6="Working Through Grid - 30 min"),P6/1.5,OR(C6="60 min",C6="30 min"),P6,True,"")

 

[Fluff]

How about

=IF(OR(C6={"Working Through Grid - 60 min","Working Through Grid - 30 min"}),P6/1.5,P6)

 

[j4ymf]

WOW both thank you so much

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[j4ymf]

Evening

how do i add to this formula IF N7 = 1 / total by 2 after its / it by 1.5


=IF(OR(C7={"Working Through Grid - 60 min","Working Through Grid - 30 min","Working Through Grid - 120 min"}),O7/1.5,O7)


Thank you

 

[Fluff]

How about

=IF(OR(C7={"Working Through Grid - 60 min","Working Through Grid - 30 min","Working Through Grid - 120 min"}),IF(N7=1,O7/3,O7/1.5),O7)

 

[j4ymf]

Fluff, you are a star, thats brilliant
sorry, Didnt realise i could have N7 as 1 or 2or 3or 4or 5

Tried but couldnt get it to work, would you mind 1 last time and correct it for me please


=IF(OR(C7={"Working Through Grid - 60 min","Working Through Grid - 30 min","Working Through Grid - 120 min"}),IF(N7=1,N7=2,O7/3,O7/1.5),O7)

massive thumbs up tp you

 

[Fluff]

How about

=IF(OR(C7={"Working Through Grid - 60 min","Working Through Grid - 30 min","Working Through Grid - 120 min"}),IF(OR(N7={1,2}),O7/3,O7/1.5),O7)

 

[j4ymf]

Hello Fluff

=IF(OR(C10={"Working Through Grid - 60 min","Working Through Grid - 30 min","Working Through Grid - 120 min"}),IF(OR(N10={1,2,3,4,5}),O10/P10,O10/1.5),O10)

if one seal is O6 @ £19.20
N7 = (+1) £19.20 + £19.20 = £38.40
O10= (+4) £19.20 x5 = 96.00

After playing i now realise that i may need a different formula
L= The rate
N = Identical of the same value

because N changes ive had to use the values in P to get the basic of 1 basic rate
Does that make sence, could you change this bit to work for me please

N10={1,2,3,4,5}),O10/P10

Thank you so much