Forum Discussion

Copper Contributor

Jun 03, 2021

Solved

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

Formulas and Functions

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

5 Replies

SergeiBaklan
Diamond Contributor
Jun 03, 2021
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 ))))
- im_tanmaya
  Copper Contributor
  Jun 04, 2021
  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.
  - SergeiBaklan
    Diamond Contributor
    Jun 04, 2021
    im_tanmaya , you are welcome, glad it helped
mtarler
Silver Contributor
Jun 03, 2021
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))))
- im_tanmaya
  Copper Contributor
  Jun 04, 2021
  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.

Resources