Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter past blank rows | Excel Discussion (Misc queries) | |||
Date/If function for past dues | Excel Worksheet Functions | |||
Past Due - Due Dates | Excel Worksheet Functions | |||
Cannot scroll up past a certain row | Excel Discussion (Misc queries) | |||
How to set up past due notices based on dates | Excel Discussion (Misc queries) |