formula returns #value

[widman]

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)?

 

[Dave F]

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

 

[widman]

thanks. that did it

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.

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)?