Is this what you're looking for?

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"arifnj" wrote in message
...
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