Celticshadow
Active Member
- Joined
- Aug 16, 2010
- Messages
- 414
- Office Version
- 365
- Platform
- Windows
Hi All
I am using the value function to convert possible text to a number in col A, however can I use the ISERROR function within this also as some cells are blank and with the Value function return #value as below.
<tbody>
</tbody>
Thanks in advance.
Regards
I am using the value function to convert possible text to a number in col A, however can I use the ISERROR function within this also as some cells are blank and with the Value function return #value as below.
Text Values | With Value Function Returns as below | Data Required possibly using ISERROR |
7.15 | 7.15 | 7.15 |
#value | ||
7.15 | 7.15 | 7.15 |
#value |
<tbody>
</tbody>
Thanks in advance.
Regards