Still looking for answer that works,&.appreciate past efforts

[Guest]

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 total as “CKLOG†column G is populated.

How do i keep $173.07 form appearing in "J" until a entry value appears in
“Cklog’s†G Column?

I have tried :
Ø =IF(ISNUMBER(CKLOG!G7),"",BUDGET!$D$19)
Ø =IF(ISBLANK(CKLOG!G7),"",BUDGET!$D$19)
Ø =IF(CkLog!G7="","",BUDGET!$D$19)

The first two apparently, return “True†because of the formula in CKLOG!G7
regardless of any value derived from the formula. I have no idea why the
third doesn’t work!
________________________________________________________
“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.|12DATE | GROSS | NET INCOME
6.|
7.| 17FEB06 $191.05 $167.52 ß “G7†has formula
=F7*(1-.0.123)

 

[Pete_UK]

It might be that you have a space character in CkLog!G7 and that would
prevent your third formula from working. Select that cell and press
<delete>, and then see if your third formula works.

Hope this helps.

Pete