I have three sheets "Disbursements", "Budget", and. "Cklog"

"Disbursements" has a column "J" labeled FOOD which contains =BUDGET!$D$19
in 26 cells.. This causes $173.07 to appear in all cells in column "J".
Column "J" is totaled at the bottom causing a annualized total instead of an
accumulated to total as the column is populated.

How do i keep $173.07 form appearing in "J" until a entry value appears in
Cklogs NET Column?

I have tried :
=IF(ISNUMBER(CKLOG!G7),"",BUDGET!$D$19)
=IF(ISBLANK(CKLOG!G7),"",BUDGET!$D$19)
Both apparently, return €œTrue€� because of the formula in CKLOG!G7 regardless
of any value derived from the formula
__________________________________________________ _____________

€œBudget€� contains several line items annualized in column €œC€� and /26 (pay
periods) in €œD.
________B______________C_______________D________
17.| CATEGORY | ANNUALIZED | PER PAY PERIOD
18.|
19.| Food $4500.00 $173.07 < €œD19 has
formula
=C19/26
__________________________________________________ _____________
"Cklog" has a column (G) labeled "Net Income". Net is calculated for each
paycheck

_____E___________F__________G_____
5.| DATE | GROSS | NET INCOME
6.|
7.| 17FEB06 $191.05 $167.52 < €œG7€� has formula
=F7*(1-.0.123)
8.| 03MAR06

=IF(CKLOG!G7="","",BUDGET!$D$19)

isblank returns only true if the cell is empty but since you have a formula
it is not, ="" on the other hand will


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Denny Crane" wrote in message
...
I have three sheets "Disbursements", "Budget", and. "Cklog"

"Disbursements" has a column "J" labeled FOOD which contains =BUDGET!$D$19
in 26 cells.. This causes $173.07 to appear in all cells in column "J".
Column "J" is totaled at the bottom causing a annualized total instead of
an
accumulated to total as the column is populated.

How do i keep $173.07 form appearing in "J" until a entry value appears in
Cklogs NET Column?

I have tried :
=IF(ISNUMBER(CKLOG!G7),"",BUDGET!$D$19)
=IF(ISBLANK(CKLOG!G7),"",BUDGET!$D$19)
Both apparently, return €œTrue€� because of the formula in CKLOG!G7
regardless
of any value derived from the formula
__________________________________________________ _____________

€œBudget€� contains several line items annualized in column €œC€� and /26 (pay
periods) in €œD.
________B______________C_______________D________
17.| CATEGORY | ANNUALIZED | PER PAY PERIOD
18.|
19.| Food $4500.00 $173.07 < €œD19
has
formula
=C19/26
__________________________________________________ _____________
"Cklog" has a column (G) labeled "Net Income". Net is calculated for each
paycheck

_____E___________F__________G_____
5.| DATE | GROSS | NET INCOME
6.|
7.| 17FEB06 $191.05 $167.52 < €œG7€� has formula
=F7*(1-.0.123)
8.| 03MAR06