Using if formula with OR

[arif]

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

plz find a sample file attached herewith and provide solution

thanks

 

[Khalid NGO]

Hi,
Try this:
=IF(ISBLANK(C8),"",IF(OR(C8="S.S.",C8="English"),100,IF(OR(C8="Theory",C8="Practical"),25,50)))

 

[Somendra Misra]

Hi Arif,

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

Regards,

 

[prasaddn]

Hi,

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

Regards,
Prasad DN