Fomrula with 2 pages

H

Hess S.

I have a formula for a checkbook(=IF(B4="+",K3+E4,K3-E4)). B4 is whether it is a deposit or withdrawal. K3 is the starting balence and E4 is the amount added

I was wondering if anybody knew of a way that I could change this formula so that I could have the rest of the entries on a second page. I mean, have K3(on sheet two) look at K50(final balance) on sheet one, and then continue with the rest of the formula. Please help soon. I need this spreadsheet done for my business meeting on Friday of next week

Hess
 
P

Peter Atherton

Hess

=IF(B4="+",Sheet2!K3+Sheet2!K4,Sheet2!K3-Sheet2!K4)

entered on sheet 3 or elsewhere.

However, if you create names for these cells you can use
the names omitting the sheet refs.

e.g =if(b4="+",B/Fwd+Amnt,B/Fwd-Amnt)

Regards
Peter
-----Original Message-----
I have a formula for a checkbook(=IF(B4="+",K3+E4,K3-
Click to expand...
E4)). B4 is whether it is a deposit or withdrawal. K3 is
the starting balence and E4 is the amount added.
I was wondering if anybody knew of a way that I could
Click to expand...
change this formula so that I could have the rest of the
entries on a second page. I mean, have K3(on sheet two)
look at K50(final balance) on sheet one, and then continue
with the rest of the formula. Please help soon. I need
this spreadsheet done for my business meeting on Friday of
next week.
 
Top