Forum Discussion

Chris Nel's avatar
Chris Nel
Copper Contributor
Nov 10, 2017
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...
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Nov 10, 2017

    Hi Chris,

     

    Try to replace this formula:

    =AND(N21>0,N21<33)

    By this:

    =AND(VALUE(N21)>0,VALUE(N21)<33)

     

     

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Nov 10, 2017

Hi Chris,

 

Try to replace this formula:

=AND(N21>0,N21<33)

By this:

=AND(VALUE(N21)>0,VALUE(N21)<33)

 

 

  • Chris Nel's avatar
    Chris Nel
    Copper Contributor
    Nov 10, 2017
    Thank you Haytham! 'Value' - Of course. Now for the next part, using this formula in conditional formatting!

Resources