The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Right, basically I am making a spreadsheet and I want to be able to do the following:
I have a cell that is going to have a numerical value of 0 in it. I also have 2 other cells, what I want to be able to do is enter a value into 1 cell, then click a form button and have that value added into the original cell. The second cell should be able to do exactly the same thing, except when I click the form button it should decrease the value entered from the original cell.
Basically I havent got a clue how to do this. I know how to record macros etc. but I have no knowledge of where to start, or VB for that matter so I was wondering if anyone had any idea of how to do this?
Thx in advance.
I have a cell that is going to have a numerical value of 0 in it. I also have 2 other cells, what I want to be able to do is enter a value into 1 cell, then click a form button and have that value added into the original cell. The second cell should be able to do exactly the same thing, except when I click the form button it should decrease the value entered from the original cell.
Basically I havent got a clue how to do this. I know how to record macros etc. but I have no knowledge of where to start, or VB for that matter so I was wondering if anyone had any idea of how to do this?
Thx in advance.
Oh and it's easier sometime to just type the formula out and move around with the cursor as the autoformula thingy is sometimes a bit of a pain in the butt :)
Ok...sorry I've only just got round to this. Right number one, you've basically got 5 colums.
Column A - Full of zeros
Column B - Has some figures which need to be added to zero
Column C - Has some figures which need to be subtracted from zero
Column D - Column A plus Column B
Column E - Column A minus Column C
The formula for column D is =IF(B2>0,A2+B2,0)
The formula for columd E is =IF(C2>0,A2-C2,0)
Both formulas assume that the cells in column B & C are positive numbers.
I just run this along row 2 which is why they are like that but you can manipulate it as you want.
If I've read that wrong then let me know.
Column A - Full of zeros
Column B - Has some figures which need to be added to zero
Column C - Has some figures which need to be subtracted from zero
Column D - Column A plus Column B
Column E - Column A minus Column C
The formula for column D is =IF(B2>0,A2+B2,0)
The formula for columd E is =IF(C2>0,A2-C2,0)
Both formulas assume that the cells in column B & C are positive numbers.
I just run this along row 2 which is why they are like that but you can manipulate it as you want.
If I've read that wrong then let me know.
Right, IF syntax is =IF(logical_test,value_if_true,value_if_false)
Basically what I understand from this is I can create a formula such as =IF(g16>1,10,0) however I dont understand how I can create the forumula to add the number that I actually enter instead of just making it a set number.
Any help?
Basically what I understand from this is I can create a formula such as =IF(g16>1,10,0) however I dont understand how I can create the forumula to add the number that I actually enter instead of just making it a set number.
Any help?
I dont specifically need to use forms no, IF statements are something that have been asked to be used however. The only problem is my excel knowledge is VERY basic and judging on the way you said a simple IF statement it kind of shows that. Any chance you could show me the kind of formula I am looking for?
Could you not just use a simple IF statement in seperate columns?
IF you put a figure in cell B1 add it to A1 and output in D1
IF you put a figure in cell C1 subtract it from A1 and output in E1
Or do you specifically need to use forms?
IF you put a figure in cell B1 add it to A1 and output in D1
IF you put a figure in cell C1 subtract it from A1 and output in E1
Or do you specifically need to use forms?
I haven't a clue, if you don't get any joy here, do as I did, get a Excel book from the library !
Well I've finished my entire spreadsheet now. Just cant complete it without some help with this problem. Any help will be vastly appreciated.
Right, basically I am making a spreadsheet and I want to be able to do the following:
I have a cell that is going to have a numerical value of 0 in it. I also have 2 other cells, what I want to be able to do is enter a value into 1 cell, then click a form button and have that value added into the original cell. The second cell should be able to do exactly the same thing, except when I click the form button it should decrease the value entered from the original cell.
Basically I havent got a clue how to do this. I know how to record macros etc. but I have no knowledge of where to start, or VB for that matter so I was wondering if anyone had any idea of how to do this?
Thx in advance.
I have a cell that is going to have a numerical value of 0 in it. I also have 2 other cells, what I want to be able to do is enter a value into 1 cell, then click a form button and have that value added into the original cell. The second cell should be able to do exactly the same thing, except when I click the form button it should decrease the value entered from the original cell.
Basically I havent got a clue how to do this. I know how to record macros etc. but I have no knowledge of where to start, or VB for that matter so I was wondering if anyone had any idea of how to do this?
Thx in advance.