if function

[Guest]

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 here: if a number is at least 10 and less then 100.........
How can I create if function for this
Please help
Thank you

 

[RagDyer]

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!
==============================================

 

[Guest]

=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.

 

[Guest]

Thanks to all
I knew it was simple