software

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

Budget contains several line items annualized in one column and /26 (pay
periods) in another.
________B________________C_______________D________ _____
18.| CATEGORY ANNUALIZED PER PAY PERIOD
19.| Food $4500.00 $173.07quot;Cklogquot; has a column (G8) labled quot;Net Incomequot;. Net is calculated for each
pay check

_____E________________F_______________G___________ __
DATE GROSS NET

8.| 17FEB06 $191.05 $167.52
9.| 03MAR06quot;Disbursementsquot; has a column quot;Jquot; labeled FOOD which contains =BUDGET!$D$19
copied to all cells (26) in column quot;Jquot;. 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 to total.

How do i keep $173.07 form appearing in quot;Jquot; until a new entry appears in
Cklog[s NET ColumnTry something like ...
=If(isblank(CKLOG!$G9),quot;quot;,BUDGET!$D$19)
Rgds,
ScottOquot;Denny Cranequot; lt;Denny gt; wrote in
message ...
| I have three sheets quot;Budgetquot;, quot;Cklogquot; and quot;Disbursementsquot;.
|
| Budget contains several line items annualized in one column and /26
(pay
| periods) in another.
| ________B________________C_______________D________ _____
| 18.| CATEGORY ANNUALIZED PER PAY PERIOD
| 19.| Food $4500.00 $173.07
|
|
| quot;Cklogquot; has a column (G8) labled quot;Net Incomequot;. Net is calculated
for each
| pay check
|
| _____E________________F_______________G___________ __
| DATE GROSS NET
|
| 8.| 17FEB06 $191.05 $167.52
| 9.| 03MAR06
|
|
| quot;Disbursementsquot; has a column quot;Jquot; labeled FOOD which contains
=BUDGET!$D$19
| copied to all cells (26) in column quot;Jquot;. 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 to total.
|
| How do i keep $173.07 form appearing in quot;Jquot; until a new entry
appears in
| Cklog[s NET Column
|
Scott thanks for your imput however, BUDGET copies to the cell holding the
formula wether CKLOG is blank or not.
Of course, i only want it to copy when there is a value in Cklog

I don't know, it mighjt be the MadCow but, if you have some other ideas I
would like to try them.

quot;ScottOquot; wrote:

gt; Try something like ...
gt; =If(isblank(CKLOG!$G9),quot;quot;,BUDGET!$D$19)
gt; Rgds,
gt; ScottO
gt;
gt;
gt; quot;Denny Cranequot; lt;Denny gt; wrote in
gt; message ...
gt; | I have three sheets quot;Budgetquot;, quot;Cklogquot; and quot;Disbursementsquot;.
gt; |
gt; | Budget contains several line items annualized in one column and /26
gt; (pay
gt; | periods) in another.
gt; | ________B________________C_______________D________ _____
gt; | 18.| CATEGORY ANNUALIZED PER PAY PERIOD
gt; | 19.| Food $4500.00 $173.07
gt; |
gt; |
gt; | quot;Cklogquot; has a column (G8) labled quot;Net Incomequot;. Net is calculated
gt; for each
gt; | pay check
gt; |
gt; | _____E________________F_______________G___________ __
gt; | DATE GROSS NET
gt; |
gt; | 8.| 17FEB06 $191.05 $167.52
gt; | 9.| 03MAR06
gt; |
gt; |
gt; | quot;Disbursementsquot; has a column quot;Jquot; labeled FOOD which contains
gt; =BUDGET!$D$19
gt; | copied to all cells (26) in column quot;Jquot;. This causes $173.07 to
gt; appear in all
gt; | cells in column quot;Jquot;. Column quot;Jquot; is totaled at the bottom causing a
gt; | annualized total instead of an accumulated to total.
gt; |
gt; | How do i keep $173.07 form appearing in quot;Jquot; until a new entry
gt; appears in
gt; | Cklog[s NET Column
gt; |
gt;
gt;
gt;