Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract
I have cell A1 and Cell A2.
A1=5 A2=no value yet. I want to be able to type in a value in A2 that already has a formula which subtracts A1 from the value I typed in. Example, A1=5. When I type 15 in A2, I want to see the result of 10 in A2(hence the difference of A2-A1) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract
Hi Henry
Use =IF(A2<"",A2-A1,"") If A2 is not empty, then do the subtraction, else do nothing. The "" are two double quotes, aka 'speech signs" best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "henryshuttle" wrote in message ... I have cell A1 and Cell A2. A1=5 A2=no value yet. I want to be able to type in a value in A2 that already has a formula which subtracts A1 from the value I typed in. Example, A1=5. When I type 15 in A2, I want to see the result of 10 in A2(hence the difference of A2-A1) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract
You can't type in a value AND have a formula in the same cell. The value will
simply replace the formula. "henryshuttle" wrote: I have cell A1 and Cell A2. A1=5 A2=no value yet. I want to be able to type in a value in A2 that already has a formula which subtracts A1 from the value I typed in. Example, A1=5. When I type 15 in A2, I want to see the result of 10 in A2(hence the difference of A2-A1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hOW DO i SUBTRACT COLUMNS IN EXCEL? | Excel Discussion (Misc queries) | |||
HOW DO YOU ADD & SUBTRACT IN ONE COLUMN | Excel Worksheet Functions | |||
Subtract text in one cell from another? | Excel Worksheet Functions | |||
Subtract entire sheet? | Excel Worksheet Functions | |||
subtract all numbers in an array | Excel Worksheet Functions |