| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine Value of Cell?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine color of a cell? | Excel Worksheet Functions | |||
| How can I determine cell color? | Excel Discussion (Misc queries) | |||
| How can I determine if a cell has a value (#) or a formula (X*Y)? | Excel Discussion (Misc queries) | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
Threaded Mode
