if function
 

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

if function
 

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

if function
 

=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

if function
 

Thanks to all
I knew it was simple