10 Advence Excel - IF OR Function

   टीप : Smart-phone मध्ये  screen Rotate केल्यास file accurate दिसेल.

Advance Excel-Excel-2013 

This Topic

IF OR Function

Format

Sr.no  |  Name  |  Permanent  |  Salary In RS  |  If Or Bonus  |  If and Bonus

Condition

Bonus     =     10%

Permanent     >=     10000

Formula

 Bonus

 = IF(OR(E12="Yes",F12>=10000),F12*$D$7,"No bonus") Enter

 Bonus 

= IF(and(E12="Yes",F12>=10000),F12*$D$7,"No bonus") Enter

E12 = Employee Permanent click,

F12= employee Salary click

$D$7 = 10% Click