Determine Value of Cell?
hi
=if(ISNUMBER(B1),B1*1,"")
regards
FSt1
" wrote:
Here's what I got:
A1=1007543
A2=10C49
B1=formula:mid(A1,3,2) [which displays 07]
B2=formula:mid(A1,3,2) [which displays C4]
C1=formula: B1*1 [which displays 7]
C2=formula: B2*1 [which displays #VALUE]
I'm trying to write a function for C that will display [blank] where
there is a 'character' in B and a [number] where there is a 'number'
in B.
I've tried:
isnumber - they aren't numbers
value - still get #value for C2
Any other ideas?
-Bruce
|