Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula not working
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? |
#2
|
|||
|
|||
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 "KC Mao" wrote in message om... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I've got a formula for stones and pounds - how do I get an excel . | Charts and Charting in Excel | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
In Excel, I need a date math formula... | Excel Discussion (Misc queries) | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) | |||
Repeating formula in Excel | Excel Discussion (Misc queries) |