How do I set up formulas to change other worksheets' cells?

[Guest]

I've got several worksheets set up for accounting purposes. On one worksheet
I have my account balance totals and on another I have individual
transactions.

How do I set up cells on the transactions worksheet with a formula to change
values on the account balance worksheet?

For instance, on the transactions worksheet, if I have a "Cash" transaction
and one of the cells is labeled so, I want to set up a formula that will
change the account balance on another worksheet automatically.

I know it has something to do with "IF" functions, so I was trying something
like this (which is totally wrong):

=IF(C3="Cash", DISPLAY Budget!$C$9(Budget!$C$10-October!$Q$2)

Help?

 

[Harald Staff]

Hi
Formulas can't change other cells, it can only return a single value to its
own cell. So your subject question is not possible to solve.

Ypou either need a macro, or set up formulas to evaluate conditions in other
cells. Like
B1:
=IF(A1>10,"y","n")
C1:
=IF(B1="y",D14,E12)

HTH. Best wishes Harald

 

[Arvi Laanemets]

Hi

I think OP has simply to rephrase his question:
"How can formulas in a cells on AccountBalacne worksheet refer to
cells/ranges on Transactions worksheet?"


So a couple of examples here:

To return the value from cell Transactions!A2
=Transactions!A2

To sum values in range Transactions!A2:A1000
=SUM(Transactions!A2:A100)

To count cells in range Transactions!A2:A1000, containing a name "John"
=SUMIF(Transactions!A2:A100,"John")

etc.


Arvi Laanemets