=IF(ISNUMBER(VALUE(L73)),VALUE(L73),"NO")
This should also work. If you want the output to include "+", you will have
to change the format.
"Jambruins" wrote:
How do you get excel to recognize the data as a number when using the right
or left formula? For example, cell L73 has the following formula:
=RIGHT(D3,5)
The data this equation produces is +137. I have another cell that has a
formula that says =IF(ISNUMBER(L73),L73,"NO"). The answer I get is NO. I
should get +173. I have formatted cell L73 to be a number.
How do I fix this formula? Thanks
|