Jun 03 2021 07:20 AM
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 07:28 AM
@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))))
Jun 03 2021 08:21 AM
SolutionPerhaps
=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
))))
Jun 04 2021 07:03 AM
Jun 04 2021 07:08 AM
Jun 04 2021 07:27 AM
@im_tanmaya , you are welcome, glad it helped
Jun 03 2021 08:21 AM
SolutionPerhaps
=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
))))