ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,832
- Office Version
- 2007
- Platform
- Windows
Hi,
I am not sure if my title explains it correctly but code in cell K33 is shown below.
On my worksheet i have the following worksheets
Income 1,2 & 3
Expenses 1 through to 8
Here is an emample of my issue.
Worksheet Income (1) has a running total shown in cell G32
There is also a running total in the uncomplete worksheet Expenses (1) at present in cell K33
So if i look at any worksheet expense other than (1) cell K33 shows the running balance even if this worksheet has no values yet.
Basically i would like cell K33 on any other worksheet Expense to be shown empty until i actually start to enter values on the said worksheet.
Not sure if the code below can be edited BUT you could do something with this example when i activate the page maybe.
Something like If cell D4 has no value then cell K33 value must be hidden BUT if cell D4 has a value then show value in cell K33
I am not sure if my title explains it correctly but code in cell K33 is shown below.
On my worksheet i have the following worksheets
Income 1,2 & 3
Expenses 1 through to 8
Here is an emample of my issue.
Worksheet Income (1) has a running total shown in cell G32
There is also a running total in the uncomplete worksheet Expenses (1) at present in cell K33
So if i look at any worksheet expense other than (1) cell K33 shows the running balance even if this worksheet has no values yet.
Basically i would like cell K33 on any other worksheet Expense to be shown empty until i actually start to enter values on the said worksheet.
Not sure if the code below can be edited BUT you could do something with this example when i activate the page maybe.
Something like If cell D4 has no value then cell K33 value must be hidden BUT if cell D4 has a value then show value in cell K33
Code:
=SUM('INCOME (1)'!G32 -'EXPENSES (4)'!K32)-MILEAGE!C32