if function

[easyshot]

I am trying to make up a simple check reg. add subtract. what I would like to know is if I can use the if function to post to column I if I put an x in column c but not have it post in column H? Here is the formula that I wrote to get this far.
=sum(h3-g4)+e4-f4
Thanks in advance Henry

 

[Juan Pablo González]

On 2002-10-19 09:44, easyshot wrote:
I am trying to make up a simple check reg. add subtract. what I would like to know is if I can use the if function to post to column I if I put an x in column c but not have it post in column H? Here is the formula that I wrote to get this far.
=sum(h3-g4)+e4-f4
Thanks in advance Henry

First, the function you wrote doesn't need the SUM function, since you're only supplying one parameter, so, you could just use

=H3-G4+E4-F4

now... you want this formula in column I, to check if there's an "X" in column C and do what to column H ?

the IF function works like this

=IF(some_test, do_something_if_its_true,do_something_if_its_false)

 

[easyshot]

column e is a deposit column. Column h is the balance column, I is savings. What I would like to do is post a number in column e and have it post in column I with out adding to h. Column e is multi purpose for checking and savings
Henry

 

[Juan Pablo González]

Can you put some example data along with expected results ? I'm not clear with what you want.

 

[easyshot]

The spred sheet is a check regester. When I what to enter a deposit in column e it automaticly adds to column h if I have any fees it subtracts them from h and when I enter an amount in column g it subtracts from h also. I would like to enter a number in column e and have it put it in column i but not add it to column h is this posiable? Henry