Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
if function
Thanks to all
I knew it was simple |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |