Excel formula not working

  • Thread starter Thread starter KC Mao
  • Start date Start date
K

KC Mao

I encounter a Excel problem, let me explain it in a examble:

A1=10
B1=20
C1=2000
D1=20
E1=C1-A1-B1-C1
E1 will shows value 1950

Then Copy E1 all the column down to E10
There are not values in cells below A1, B1, C1, and D1.

Cells E2~E10 should show value 0

However, they show 1950, the same value as E1.

ANyone have this problem before?
 
Hi

(ignoring the error in the formula in E1)

check that tools / options / calculation is set to automatic

if that is not the problem please copy & paste the formula in cell E2 into
your reply psot.

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 storing the high and low 3
Formula for If "" AND "" are true... 3
Multiple if condition formula required 4
Copy/Paste formulas in merged cells 2
How To Have A Cell Be Blank If... 2
Finding minum positive from the result of formula 8
How to copy the function SUM but offseted in 7 columns 2
Merging rows based on column value 2

Back
Top