[Solved] Using multiple IF/AND formulas
Posted: Thu Oct 31, 2024 8:07 pm
TIME ITEMS MULTIPLIER MULTIPLIER 2 MULTIPLIER 3 9.0 10 0.45 0.51 0.6
To get multiplier 0.45 i did this { =IF(AND(J2<=9,K2<=10),0.45,0) }
To get multiplier 0.51 I did this {=IF(AND(L2=0.45,K2>=10),0.51,0) }
To get multiplier 0.6 I did this { =IF(AND(M2=0.51,K2>=40),0,0.6) }
What I cannot figure out is how to have only one column (Multiplier)
and as time and items change the multiplier changes accordngly..
Tried hard to make this work.. =IF(AND(J2<=9,K2<=10),0.45,=IF(AND(L2=0.45,K2>=10),0.51,=IF(AND(M2=0.51,K2>=40),0,0.6)))
with no luck..
If TIME is <=9 and ITEMS <= 9 I want 0.45
If TIME is <=9 and ITEMS >= 10 I want 0.51 This will accur each day of the week hopfully..
If TIME is <=9 and ITEMS > 40 I want 0.60
I have been beating myself up trying to put it all in one formula but don't have pizzaz to do it...
So asking for help to understand it..MANY THANKS
Cub