| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Brain fart in simple subtraction
How do I fix a cell that is always subtracted from?
I want to have b2 a fixed value then c3=b2-b3 d3=b2-d3 e3=b2-e3 If I just pull cell down to copy I get d3=b3-b4 e3=b4-b5 Brain fart I am sure :) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Brain fart in simple subtraction
=$B$2-B3
See help on absolute and relative references. BTW your examples show you are copying across, not down C3, D3 and E3 are in same row. Gord Dibben MS Excel MVP On Fri, 13 Nov 2009 11:18:39 -0500, "Fritz W" wrote: How do I fix a cell that is always subtracted from? I want to have b2 a fixed value then c3=b2-b3 d3=b2-d3 e3=b2-e3 If I just pull cell down to copy I get d3=b3-b4 e3=b4-b5 Brain fart I am sure :) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Brain fart in simple subtraction
Hi,
use c3=$b$2-b3 "Fritz W" wrote: How do I fix a cell that is always subtracted from? I want to have b2 a fixed value then c3=b2-b3 d3=b2-d3 e3=b2-e3 If I just pull cell down to copy I get d3=b3-b4 e3=b4-b5 Brain fart I am sure :) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple subtraction | Excel Worksheet Functions | |||
| simple subtraction | New Users to Excel | |||
| Subtraction brain block | Excel Discussion (Misc queries) | |||
| Simple, Monday morning brain function | Excel Worksheet Functions | |||
| Simple, Monday morning brain function | Excel Worksheet Functions | |||
Linear Mode
