Page 54 - COMPUTER

 Logical Function 

➢ =If():- The If() Function Is Used To Determine Whether A Condition Is True Or False.
One Value Is Referred If The Condition Is True And A Different Value Is Referred If The
Condition Is False.
Syntax:- =If(Condition, True Value, False Value)
Example :- =If(G2>200, “Pass”, “Fail”)

Interest

Customer Deposit
Id Name Amt Age Interest Total
Pnb/001 Reyaz 125400 27 14421 139821
Pnb/002 Anam 215400 60 25848 241248
Pnb/003 Kanchan 283000 34 32545 315545
Pnb/004 Muskan 3250000 38 373750 3623750
Pnb/005 Kajal 1570000 21 180550 1750550
Pnb/006 Farheen 3568000 16 463840 4031840
Pnb/007 Arshna 32580000 37 3746700 36326700
Pnb/008 Deepa 3465000 18 398475 3863475
Pnb/009 Shamar 32654000 34 3755210 36409210
Pnb/010 Zeba 25300000 80 3415500 28715500

Pnb
Age Interest Rate
<18 13%
<=45 11.50%
<=60 12%
>60 13.50%
Result:
=If(((Sum(M3,G3,J3,P3,D3))/(Sum(O3,L3,I3,F3,C3,))*100)>40,"Pass","Fail")
Total Percentage:-
=((Sum(M3,G3,J3,P3,D3))/(Sum(O3,L3,I3,F3,C3,))*100)
Grade:-
=If(S3>90,"A1",If(S3>80,"A2",If(S3>70,"B1",If(S3>60,"B2",If(S3>60,"C",If(S3>50,"D",If(
S3>40,"E","F")))))))

53