Forum Discussion
Solved
AND formula not giving correct result
Hi All, I am using a simple formula using the AND function and it will not give me correct results. For example: In cell N20, I have the text 1-30 as the result of this formula:- =IFERROR(INDE...
Hi Chris,
Try to replace this formula:
=AND(N21>0,N21<33)
By this:
=AND(VALUE(N21)>0,VALUE(N21)<33)
PS I have manually changed the value in cell N21 to 30 and the AND formula works. So, how does one analyse the numerical result of a formula with the AND function?
The problem that you have is the numbers in your worksheets are considered as texts; because you got them through the text function RIGHT!
So, you have to parse them and convert them to actual numbers to get the right results.
You can surround those numbers by VALUE function, you can also use NUMBERVALUE function if you have Excel 2013 and later.