software

I have three sheets quot;Disbursementsquot;, quot;Budgetquot;, and. quot;Cklogquot;

quot;Disbursementsquot; has a column quot;Jquot; labeled FOOD which contains =BUDGET!$D$19
in 26 cells.. This causes $173.07 to appear in all cells in column quot;Jquot;.
Column quot;Jquot; 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 quot;Jquot; until a entry value appears in
“Cklog’s” G Column?

I have tried :
Ø=IF(ISNUMBER(CKLOG!G7),quot;quot;,BUDGET!$D$19)
Ø=IF(ISBLANK(CKLOG!G7),quot;quot;,BUDGET!$D$19)
Ø=IF(CkLog!G7=quot;quot;,quot;quot;,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
__________________________________________________ _____________
quot;Cklogquot; has a column (G) labeled quot;Net Incomequot;. 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)
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
lt;deletegt;, and then see if your third formula works.

Hope this helps.

Pete