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
=if(and(a1=500,b1=300),200,0)
2006-12-21 19:34:49 · answer #1 · answered by Meridianhawk42 3 · 0⤊ 0⤋
a1 500 b1 300 c1 200
A1, 000 B1 000 C1 +a1 -b1 ( gives c1 200 answer )
2006-12-21 19:47:05 · answer #2 · answered by Carling 7 · 0⤊ 1⤋
sort precisely as shown below, between rates (no areas): "=IF(A1=0,0,IF(A1>B1,A1-B1,0))" i've got tried it, and it works as stipulated. The case while A1 = B1 wasn't laid out on your question, so the formula will yield 0 every time this actual subject exists. The above formula mirror terrific the situations to be met as you reported them; regardless of the shown fact that, i think of that "=IF(A>B,A-B,0)" Iis lots less difficult, and could paintings besides.
2016-11-28 03:43:26 · answer #3 · answered by Anonymous · 0⤊ 0⤋