Still looking for answer that works,&.appreciate past efforts
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 €œCklogs€ 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 doesnt 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) |
Still looking for answer that works,&.appreciate past efforts
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 |
All times are GMT +1. The time now is 04:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com