• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using if formula with OR

arif

Member
How can i use if formula using "IF" with or or with

plz find a sample file attached herewith and provide solution

thanks
 

Attachments

  • If formula.xlsx
    7.4 KB · Views: 9
Hi,
Try this:
=IF(ISBLANK(C8),"",IF(OR(C8="S.S.",C8="English"),100,IF(OR(C8="Theory",C8="Practical"),25,50)))
 
Hi Arif,

Another approach, using lookup tables. Advantage is it is easy to change Max marks across all cells in a single change.

Regards,
 

Attachments

  • If formula.xlsx
    8.4 KB · Views: 7
Hi,

In continuation to SM's formula, here is another alternate:
=IFERROR(VLOOKUP(C8,$O$3:$P$7,2,0),50)

Regards,
Prasad DN
 
Back
Top