Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula contains "" but cell still shows a value
I've "inherited" a workbook, and it contains the formula
=IF(A13<"",NETWORKDAYS(B13,G13,Holidays!$B$1:$B$2 8),"") The problem is that G13 has no value but the results cell has a value of -28053 which makes no sense. A13 has a value. Can someone tell me how to have the cell be blank when no value is in G13? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula contains "" but cell still shows a value
Maybe
=IF(AND(A13<"",G13<""),NETWORKDAYS(B13,G13,Holid ays!$B$1:$B$28),"") Mike "Glenn" wrote: I've "inherited" a workbook, and it contains the formula =IF(A13<"",NETWORKDAYS(B13,G13,Holidays!$B$1:$B$2 8),"") The problem is that G13 has no value but the results cell has a value of -28053 which makes no sense. A13 has a value. Can someone tell me how to have the cell be blank when no value is in G13? Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula contains "" but cell still shows a value
That's fantastic Mike! Thank you for the quick and correct solution.
"Mike H" wrote: Maybe =IF(AND(A13<"",G13<""),NETWORKDAYS(B13,G13,Holid ays!$B$1:$B$28),"") Mike "Glenn" wrote: I've "inherited" a workbook, and it contains the formula =IF(A13<"",NETWORKDAYS(B13,G13,Holidays!$B$1:$B$2 8),"") The problem is that G13 has no value but the results cell has a value of -28053 which makes no sense. A13 has a value. Can someone tell me how to have the cell be blank when no value is in G13? Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula contains "" but cell still shows a value
Your welcome and thanks for the feedback
"Glenn" wrote: That's fantastic Mike! Thank you for the quick and correct solution. "Mike H" wrote: Maybe =IF(AND(A13<"",G13<""),NETWORKDAYS(B13,G13,Holid ays!$B$1:$B$28),"") Mike "Glenn" wrote: I've "inherited" a workbook, and it contains the formula =IF(A13<"",NETWORKDAYS(B13,G13,Holidays!$B$1:$B$2 8),"") The problem is that G13 has no value but the results cell has a value of -28053 which makes no sense. A13 has a value. Can someone tell me how to have the cell be blank when no value is in G13? Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula contains "" but cell still shows a value
I think I have a closely related question (maybe I would rewrite my title to
be "Cell appears to contain no value but Excel thinks the cell is not blank": In a given column of, say, 100 rows, only a few rows have data that is visible. These are not adjacent rows. Normally, you can press End Down to get to the next row containing data. But in my column, the empty rows have data even though they appear empty, i.e. ISBLANK(A1) = False and Len(A1) = 0...but I cannot see any data in A1. A1 should be read as a proxy for any cell in that column. I am trying to purge the apprently but not actually empty cells, so that I can use End Down as I describe above. Does that make any sense? Regards, Keith ========== "Mike H" wrote: Your welcome and thanks for the feedback "Glenn" wrote: That's fantastic Mike! Thank you for the quick and correct solution. "Mike H" wrote: Maybe =IF(AND(A13<"",G13<""),NETWORKDAYS(B13,G13,Holid ays!$B$1:$B$28),"") Mike "Glenn" wrote: I've "inherited" a workbook, and it contains the formula =IF(A13<"",NETWORKDAYS(B13,G13,Holidays!$B$1:$B$2 8),"") The problem is that G13 has no value but the results cell has a value of -28053 which makes no sense. A13 has a value. Can someone tell me how to have the cell be blank when no value is in G13? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference Shows "0" | Excel Discussion (Misc queries) | |||
Sum formula result shows "#N/A" | Excel Worksheet Functions | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |