| 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? |
| 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) | |||
Threaded Mode
