Sep 22 2020 08:35 AM
I am having problems with a formula. I'm fairly new to excel and trying to figure this out. Can anyone look at this formula and tell me what needs to be fixed? What I need it to do is that if C17 is 6 or 7, then C18 needs to be multipled by 10, but if C17 is 4 or 5 then I need C18 to be multiplied by 8, and if C17 is 2 or 3 then I need C18 to be multiplied by 6.
=IF((C17=C=6), OR(C17==7),(10*C18)),IF(A23(C17==4),OR(C17==5),(8*C18)),IF((C17==2),OR(C17==3),(6*C18))
Sep 22 2020 08:51 AM
=C18*IF(OR(C17={6,7}),10,IF(OR(C17={4,5}),8,IF(OR(C17={2,3}),6)))