SOLVED

Need Help on An Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2412547%22%20slang%3D%22en-US%22%3ENeed%20Help%20on%20An%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412547%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPls%20Help%20Me%20Out%20In%20Correcting%20The%20Following%20Formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(OR(C28%3DC13%2CC14)%2CD14)%2CIF(OR(C28%3DC15%2CC16)%2CD16)%2CIF(OR(C28%3DC19%2CC20)%2CD20)%2CIF(OR(C28%3DC23%2CC24)%2CD24)%2CD26)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2412547%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-2412577%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20on%20An%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412577%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1070381%22%20target%3D%22_blank%22%3E%40im_tanmaya%3C%2FA%3E%26nbsp%3BI'm%20assuming%20this%20list%20of%20IF%20statement%20are%20meant%20to%20be%20nesting%20in%20that%20if%20the%20condition%20is%20FALSE%20then%20go%20on%20to%20the%20next%20IF%20statement.%26nbsp%3B%20I%20recommend%20using%20IFS%20instead%20but%20both%20versions%20are%20below%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFS(OR(C28%3DC13%2CC14)%2CD14%2COR(C28%3DC15%2CC16)%2CD16%2COR(C28%3DC19%2CC20)%2CD20%2COR(C28%3DC23%2CC24)%2CD24%2C1%2CD26)%3C%2FCODE%3E%3C%2FPRE%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(OR(C28%3DC13%2CC14)%2CD14%2CIF(OR(C28%3DC15%2CC16)%2CD16%2CIF(OR(C28%3DC19%2CC20)%2CD20%2CIF(OR(C28%3DC23%2CC24)%2CD24%2CD26))))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2412829%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20on%20An%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412829%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1070381%22%20target%3D%22_blank%22%3E%40im_tanmaya%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(OR(C28%3DC13%2CC28%3DC14)%2CD14%2C%0A%20IF(OR(C28%3DC15%2CC28%3DC16)%2CD16%2C%0A%20IF(OR(C28%3DC19%2CC28%3DC20)%2CD20%2C%0A%20IF(OR(C28%3DC23%2CC28%3DC24)%2CD24%2C%0A%20D26%0A%20))))%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416329%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20on%20An%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416329%22%20slang%3D%22en-US%22%3EHi%20Mr.%20Sergei%20Baklan%2C%3CBR%20%2F%3EGood%20Evening!%3CBR%20%2F%3EThank%20you%20so%20much%20for%20this%20rectification%2C%20it%20exactly%20returned%20the%20value%20as%20I%20wanted.%3CBR%20%2F%3EThanks%20again%2C%20good%20luck.%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

 

Pls Help Me Out In Correcting The Following Formula.

 

=IF(OR(C28=C13,C14),D14),IF(OR(C28=C15,C16),D16),IF(OR(C28=C19,C20),D20),IF(OR(C28=C23,C24),D24),D26)

 

Regards

5 Replies

@im_tanmaya I'm assuming this list of IF statement are meant to be nesting in that if the condition is FALSE then go on to the next IF statement.  I recommend using IFS instead but both versions are below:

=IFS(OR(C28=C13,C14),D14,OR(C28=C15,C16),D16,OR(C28=C19,C20),D20,OR(C28=C23,C24),D24,1,D26)
=IF(OR(C28=C13,C14),D14,IF(OR(C28=C15,C16),D16,IF(OR(C28=C19,C20),D20,IF(OR(C28=C23,C24),D24,D26))))

 

best response confirmed by allyreckerman (Microsoft)
Solution

@im_tanmaya 

Perhaps

=IF(OR(C28=C13,C28=C14),D14,
 IF(OR(C28=C15,C28=C16),D16,
 IF(OR(C28=C19,C28=C20),D20,
 IF(OR(C28=C23,C28=C24),D24,
 D26
 ))))
Hi Mr. Sergei Baklan,
Good Evening!
Thank you so much for this rectification, it exactly returned the value as I wanted.
Thanks again, good luck.
Hi Mr matler, good evening!
Thank you so much for your quick response. Both of the formulas returned value as follows.
For C28=C13 it returned D14
but for C28=C14, it returned D26
Thank you again.

@im_tanmaya , you are welcome, glad it helped