Forum Discussion
im_tanmaya
Jun 03, 2021Copper Contributor
Need Help on An Excel Formula
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
- Jun 03, 2021
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 ))))
SergeiBaklan
Jun 03, 2021Diamond Contributor
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
))))
- im_tanmayaJun 04, 2021Copper ContributorHi Mr. Sergei Baklan,
Good Evening!
Thank you so much for this rectification, it exactly returned the value as I wanted.
Thanks again, good luck.- SergeiBaklanJun 04, 2021Diamond Contributor
im_tanmaya , you are welcome, glad it helped