If function to check number

[AlphaOi]

Hello all,

This will be easy to most of you, but i spent already more than couple of hours to search for solution, and cannot find correct way to work... Forgive me for being computer-illiterate.

I need function for this case:

To check value in D7 cell, and if value is only between 0-0.04 or 0.15-0.25 to show "Yes", if other - "No"...

e.g. if i change in D7 i need text to change as well: 0.02 - Yes; 0.05 - No, 0.4 - No, 0.17-Yes

Thank you for solution

Have a nice day and upcoming weekend

 

[Norie]

Perhaps.

=IF(OR(AND(D7>=0, D7<=0.04), AND(D7>=0.15, D7<=0.25)), "Yes", "No")

 

[AlphaOi]

Perhaps.

=IF(OR(AND(D7>=0, D7<=0.04), AND(D7>=0.15, D7<=0.25)), "Yes", "No")

Thank you very much, this worked!