Discussion Re: Problem with formula in Excel
https://techcommunity.microsoft.com/t5/excel/problem-with-formula/m-p/1699556#M75758
<P><LI-USER uid="127945"></LI-USER> </P><P>Thank you so much!!!</P>Tue, 22 Sep 2020 15:54:04 GMTMusetta2020-09-22T15:54:04ZProblem with formula
https://techcommunity.microsoft.com/t5/excel/problem-with-formula/m-p/1699535#M75754
<P>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.</P><P> </P><P>=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))</P>Tue, 22 Sep 2020 15:35:20 GMThttps://techcommunity.microsoft.com/t5/excel/problem-with-formula/m-p/1699535#M75754Musetta2020-09-22T15:35:20ZRe: Problem with formula
https://techcommunity.microsoft.com/t5/excel/problem-with-formula/m-p/1699554#M75757
<P><LI-USER uid="803564"></LI-USER> </P>
<P>=C18*IF(OR(C17={6,7}),10,IF(OR(C17={4,5}),8,IF(OR(C17={2,3}),6)))</P>Tue, 22 Sep 2020 15:51:54 GMThttps://techcommunity.microsoft.com/t5/excel/problem-with-formula/m-p/1699554#M75757Hans Vogelaar2020-09-22T15:51:54ZRe: Problem with formula
https://techcommunity.microsoft.com/t5/excel/problem-with-formula/m-p/1699556#M75758
<P><LI-USER uid="127945"></LI-USER> </P><P>Thank you so much!!!</P>Tue, 22 Sep 2020 15:54:04 GMThttps://techcommunity.microsoft.com/t5/excel/problem-with-formula/m-p/1699556#M75758Musetta2020-09-22T15:54:04Z