Can anyone help me with this MS Excel problem?

Question

While working with MS Excel worksheet I have come across a problem with IF and AutoSum functions. The problem is as follows:

Cell A1=3500. Cell B1 contains the following formula: =IF(A1>=3500, “200”, “150”). This formula is working very well. But, the problem is when I try to add up A1+B1 in C1 using the AutoSum function, it doesn’t work. The cell C1 shows whatever the Cell A1 contains. What formula shall I enter/use in order to get the total of A1+B1 in C1 using AutoSum function? Or is there any other way to overcome this problem?

Will anyone help me, please?

Ramesh HT

Electronic City

Bangalore-560 100

Answer 1

You can give a formula for it instead of using autosum .

For e.g.:-

If you want the sum of cell A1 and B1 in C1, then in C1 type

=sum(a1:b1)

and then press enter and you will get their total in C1.

Answer 2

try without quotes in B1 .. ie :

=IF(A1>=3500, 200, 150)

rather than =IF(A1>=3500, “200”, “150”)

Answer 3

Your formula IF was wrong it should be

=IF(A1>=3500;200;150) and you will get 150.

And add up A1+B1 by this fomula =Sum(A1:B1) you will get the correct answer that is 3650.

Answer 4

H,

In C1 enter

=B1+A1

Then it will work.

Actually in B1 formula 200 and 150 have become character because of inverted commas. so the value in b1 is a character. so if you remove the inverted commas and enter the formula like =if(a1>3500,200,150) then it will work with the normal sum function but if you keep inverted commas with the 200 and 150 then answer would be what I  mentioned above.

Try it. Its working for me.

:o)

Answer 5

Yes, I guess as mentioned by couple of more people. You need to remove quotation marks before and after 200 and 150 respectively. i.e. =IF(A1>=3500,200,150) and it should work fine.

Answer 6

Type =A1+B1 in C1. That's all.

Answer 7

Your formula should read =IF(A1>=3500,200,150). If your answer must have 200 and 150 as text use =A1+B1 in C1.