Problem with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1699535%22%20slang%3D%22en-US%22%3EProblem%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699535%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20problems%20with%20a%20formula.%20I'm%20fairly%20new%20to%20excel%20and%20trying%20to%20figure%20this%20out.%20Can%20anyone%20look%20at%20this%20formula%20and%20tell%20me%20what%20needs%20to%20be%20fixed%3F%20What%20I%20need%20it%20to%20do%20is%20that%20if%20C17%20is%206%20or%207%2C%20then%20C18%20needs%20to%20be%20multipled%20by%2010%2C%20but%20if%20C17%20is%204%20or%205%20then%20I%20need%20C18%20to%20be%20multiplied%20by%208%2C%20and%20if%20C17%20is%202%20or%203%20then%20I%20need%20C18%20to%20be%20multiplied%20by%206.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF((C17%3DC%3D6)%2C%20OR(C17%3D%3D7)%2C(10*C18))%2CIF(A23(C17%3D%3D4)%2COR(C17%3D%3D5)%2C(8*C18))%2CIF((C17%3D%3D2)%2COR(C17%3D%3D3)%2C(6*C18))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1699535%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1699556%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1699554%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F803564%22%20target%3D%22_blank%22%3E%40Musetta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DC18*IF(OR(C17%3D%7B6%2C7%7D)%2C10%2CIF(OR(C17%3D%7B4%2C5%7D)%2C8%2CIF(OR(C17%3D%7B2%2C3%7D)%2C6)))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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))

2 Replies
Highlighted

@Musetta 

=C18*IF(OR(C17={6,7}),10,IF(OR(C17={4,5}),8,IF(OR(C17={2,3}),6)))

@Hans Vogelaar 

Thank you so much!!!