Thread: IF Function
View Single Post
  #1   Report Post  
Freshman
 
Posts: n/a
Default IF Function

I've numbers "002170" in A2 and "044925" in B2. I want to put a number in C2
such that if the number is =A2 but <=B2, then a statment "It is fine" else
"" appears in D2. What the formula would be? Please correct my formula below:

=IF(D2=A2 AND D2<=B2,"It is fine","")

Another question is how can I show the number "002170" in A2 beside adding a
' in front of the number?

Thanks.