=IF(AND(A1=10, A1<100), TRUE, FALSE)

Where cell A1 contains the number you are testing. Replace TRUE and FALSE
with whatever you want the formula to do in the event the condition is met or
not met.


"arifnj" wrote:

Hi everybody
I am having difficulty to find out a formula.
I know it is simple but I tried everything and did not work.

The situation is he if a number is at least 10 and less then 100.........
How can I create if function for this
Please help
Thank you