Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple question
I'm relatively new to Excel and I want to creat a sheet for my
expenses where I can enter a number in one column and have it subtracted from the above cell in the next column and so on, all the way down. I can do this by clicking on the bottom left of the cell and dragging it down but would like it to appear automatically. Sorry if that's not very clear. John |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple question
In B1 enter the inital balance
In A2 and on down enter your expenses In B2 enter: =IF(A2="","",B1-A2) and copy on down -- Gary''s Student - gsnu2007g " wrote: I'm relatively new to Excel and I want to creat a sheet for my expenses where I can enter a number in one column and have it subtracted from the above cell in the next column and so on, all the way down. I can do this by clicking on the bottom left of the cell and dragging it down but would like it to appear automatically. Sorry if that's not very clear. John |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple question
"Gary''s Student" wrote in message ... In B1 enter the inital balance In A2 and on down enter your expenses In B2 enter: =IF(A2="","",B1-A2) and copy on down -- Gary''s Student - gsnu2007g Many thanks for the solution. John |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple question
" wrote: I'm relatively new to Excel and I want to creat a sheet for my expenses where I can enter a number in one column and have it subtracted from the above cell in the next column and so on, all the way down. I can do this by clicking on the bottom left of the cell and dragging it down but would like it to appear automatically. John "Gary''s Student" replied: In B1 enter the initial balance In A2 and on down enter your expenses In B2 enter: =IF(A2="","",B1-A2) and copy on down I, too, am unfamiliar with Excel. This =IF(A2="","",B1-A2) and copy on down appears unduly complex. It seems I get the same results if I simply put =(B1-A2) into B2 and copy *that* down. What's the significance (and meaning of) the IF(A2="","" bits, please? I'm sure your solution is to be preferred rather than mine - but why? TIA |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple question
The "" means blank. =IF(A2="",""
In this case, if cell A2 is blank, it says leave the spot where the if statement resides blank (in your example, B2). In your scenario if A1 were blank you would get !Value or some other error message. The "" in the IF statement above makes the worksheet cleaner by making the error messages not show up. It's all about esthetics. Hope this helps. -- Just a fellow Excel user here to help when I can..... "DB." wrote: " wrote: I'm relatively new to Excel and I want to creat a sheet for my expenses where I can enter a number in one column and have it subtracted from the above cell in the next column and so on, all the way down. I can do this by clicking on the bottom left of the cell and dragging it down but would like it to appear automatically. John "Gary''s Student" replied: In B1 enter the initial balance In A2 and on down enter your expenses In B2 enter: =IF(A2="","",B1-A2) and copy on down I, too, am unfamiliar with Excel. This =IF(A2="","",B1-A2) and copy on down appears unduly complex. It seems I get the same results if I simply put =(B1-A2) into B2 and copy *that* down. What's the significance (and meaning of) the IF(A2="","" bits, please? I'm sure your solution is to be preferred rather than mine - but why? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
a very simple question | Excel Discussion (Misc queries) | |||
Simple Question | Excel Worksheet Functions | |||
Simple question | Charts and Charting in Excel | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |