Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is causing a #Value!
I have several cells that appear to be empty. If I run the below formula on
them, some will return blank (which is what I want them to do, but others return #Value! It appears to be the O column, as if I take the vale from an empty "O" that is OK, and then paste it in to a broken "O", then it returns a blank. How can I correct this? Do I need to correct the data? If so, how? or do I rewrite the formula to "trap" the error? I have another formual that works against this cell, and if the error is here, I then get a error in the other formula. =IF(ISBLANK(O4),"",O4+TIME(G4,0,0)) Thanks Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is causing a #Value!
Hi Phil,
I'm guessing you have one or more spaces in the cell. Trying to add a number to a text string will give you the #VALUE! error. One way to get around this is to make sure O4 is a number: =IF(NOT(ISNUMBER(O4)),"",O4+TIME(G4,0,0)) -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Phillips wrote: I have several cells that appear to be empty. If I run the below formula on them, some will return blank (which is what I want them to do, but others return #Value! It appears to be the O column, as if I take the vale from an empty "O" that is OK, and then paste it in to a broken "O", then it returns a blank. How can I correct this? Do I need to correct the data? If so, how? or do I rewrite the formula to "trap" the error? I have another formual that works against this cell, and if the error is here, I then get a error in the other formula. =IF(ISBLANK(O4),"",O4+TIME(G4,0,0)) Thanks Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's causing error message? | Excel Worksheet Functions | |||
imported data causing row deletion | Excel Discussion (Misc queries) | |||
Rand () causing Problems. | Excel Discussion (Misc queries) | |||
Add-in causing 'GHOST' cells to be selected | Excel Programming | |||
Excel causing | Excel Programming |