A1 (previous personal allowance)= 0 or 500
B1 (house rent increased) = 300 or 600
C1 (present personal Allowance) = (?)
If A1 =0, and B1 = 300 or 600 (any figure) then C1= 0
If A1 = 500, and B1 = 300 then C1 = 200
If A1 = 500, and B1 = 600 then C1 = 0
Pls give me the solution of above problems in excel.
Give me the solutions in excel formulas.
Help me to provide right formulas in excel than I can solve the above problems.
2006-12-21
19:30:29
·
3 answers
·
asked by
e_friendship
3
in
Computers & Internet
➔ Software