Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula returns #value
I have a sheet where the formulas of E, F, and G are (in this example looking
at row 16) ColumnE =Importado!J16 Column F =LEFT(E16,FIND("/",E16)-1) column G =RIGHT(E16,LEN(E16)-FIND("/",E16)) On most items column E contains something like 2/195.20 and the formula works great to separate the 2 from the 195.2 But, if Column E happens to contain a number, such as 5, this formula returns #VALUE for both F and G How can I get F to return "0" and G to return the value of E ("5" in this case)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula returns #value
If I understand you correctly, E16 either has a number in it or a combination
of numbers and other characters. Assuming that's correct, then the following would test for whether E16 contains only numbers. =IF(ISNUMBER(E16),E16,[YOUR FORMULA]) Dave -- Brevity is the soul of wit. "widman" wrote: I have a sheet where the formulas of E, F, and G are (in this example looking at row 16) ColumnE =Importado!J16 Column F =LEFT(E16,FIND("/",E16)-1) column G =RIGHT(E16,LEN(E16)-FIND("/",E16)) On most items column E contains something like 2/195.20 and the formula works great to separate the 2 from the 195.2 But, if Column E happens to contain a number, such as 5, this formula returns #VALUE for both F and G How can I get F to return "0" and G to return the value of E ("5" in this case)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula returns #value
thanks. that did it
"Dave F" wrote: If I understand you correctly, E16 either has a number in it or a combination of numbers and other characters. Assuming that's correct, then the following would test for whether E16 contains only numbers. =IF(ISNUMBER(E16),E16,[YOUR FORMULA]) Dave -- Brevity is the soul of wit. "widman" wrote: I have a sheet where the formulas of E, F, and G are (in this example looking at row 16) ColumnE =Importado!J16 Column F =LEFT(E16,FIND("/",E16)-1) column G =RIGHT(E16,LEN(E16)-FIND("/",E16)) On most items column E contains something like 2/195.20 and the formula works great to separate the 2 from the 195.2 But, if Column E happens to contain a number, such as 5, this formula returns #VALUE for both F and G How can I get F to return "0" and G to return the value of E ("5" in this case)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
formula returns (correctly) a negative value | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |