English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

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

3 answers

=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

fedest.com, questions and answers