michaelch2934
New Member
- Joined
- Sep 17, 2018
- Messages
- 34
I have column B with either a numerical value or a letter text. In column M, I need to use only the numerical value and regard the text as 0.
In M, I entered =IF(ISNUMBER(B5),B5,0)
But, when B5=7, it returns a 0. When B5 is a T, it returns a 0 as well.
Column B is formatted as a Number (0 decimal places).
What am I doing wrong? Thanks in advance!
In M, I entered =IF(ISNUMBER(B5),B5,0)
But, when B5=7, it returns a 0. When B5 is a T, it returns a 0 as well.
Column B is formatted as a Number (0 decimal places).
What am I doing wrong? Thanks in advance!
