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