Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value in random cells
I have a formula to calculate the hours I work based upon time in and time
out - time in is deducted from time out. Since my time is based on two weeks and starts on Sunday, ending on Saturday, my formula uses the ISBLANK function, as I don't always have to come in on weekends. However, I have random #VALUE! errors in the cells that show the time worked. Most of the cells show a blank if there is no start time for the day, but I currently have the value error on Monday and Tuesday of the second week. No matter how many times I copy/paste from a working cell, or manually type in the formula, this error won't go away. Any ideas as to what I might be missing? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value in random cells
From help on error
Correct a #VALUE! error Occurs when the wrong type of argument or operand is used. Following this is a list of possible problems for you to check. The usual cause is text instead of a number. Check your time entries. Gord Dibben MS Excel MVP On Fri, 19 Jun 2009 09:58:01 -0700, Michael wrote: I have a formula to calculate the hours I work based upon time in and time out - time in is deducted from time out. Since my time is based on two weeks and starts on Sunday, ending on Saturday, my formula uses the ISBLANK function, as I don't always have to come in on weekends. However, I have random #VALUE! errors in the cells that show the time worked. Most of the cells show a blank if there is no start time for the day, but I currently have the value error on Monday and Tuesday of the second week. No matter how many times I copy/paste from a working cell, or manually type in the formula, this error won't go away. Any ideas as to what I might be missing? Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#Value in random cells
"Michael" wrote:
my formula uses the ISBLANK function, as I don't always have to come in on weekends. However, I have random #VALUE! errors in the cells that show the time worked. Most of the cells show a blank if there is no start time for the day Most likely, some cells that "show a blank" actually contain "", for example resulting from formulas of the form IF(ISBLANK(A1),"",A1+B1). Change ISBLANK(A1) to A1="". ISBLANK is true only when a cell has no formula and no constant; that is, it is completely empty. A1="" also returns true when A1 equals "". ----- original message ----- "Michael" wrote in message ... I have a formula to calculate the hours I work based upon time in and time out - time in is deducted from time out. Since my time is based on two weeks and starts on Sunday, ending on Saturday, my formula uses the ISBLANK function, as I don't always have to come in on weekends. However, I have random #VALUE! errors in the cells that show the time worked. Most of the cells show a blank if there is no start time for the day, but I currently have the value error on Monday and Tuesday of the second week. No matter how many times I copy/paste from a working cell, or manually type in the formula, this error won't go away. Any ideas as to what I might be missing? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum up random cells | Excel Worksheet Functions | |||
Transpose random series of cells | Excel Worksheet Functions | |||
Transpose random series of cells | Excel Worksheet Functions | |||
random merged cells | Excel Discussion (Misc queries) | |||
select random value in a range of cells | Excel Discussion (Misc queries) |