IF Function

F

Freshman

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

Rowan

In D2 enter =IF(AND(C2>=A2, C2<=B2),"It is fine","")

If it is always a 6 digit number you want to show then you can enter the
custom format 000000 for the cells. From the Format menu choose Cells, then
click on Custom and in the Type box type in 000000. Click on OK.

Hope this helps
Rowan
 
R

Ron Rosenfeld

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","")
Click to expand...

=IF(AND(D2>=A2,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?
Click to expand...

Format/Cells/Number/Custom Type: 000000


--ron
 
A

Armor

I am looking for a similar function.
I have a column header showing "CPU". This is to record the speed of a CPU.
I have seen the =IF(AND(D2>=A2,D2<=B2),"Comment",""); however,
I need to compare against a number entered into the cell. The desired
result is; if a number entered that is between 0.1 and 9.9 retuns the number
entered, plus the unit of measurement "GHz"; if the number entered is between
100 and 999 returns the number, plus the unit of measurement "MHz":
=IF(AND(A2>=0.1, A2<=9.9), $A$2"GHz",A$2$"MHz")... somewhere near this?
Do I need a nested IF statement?

Thank You
 
P

Peo Sjoblom

What do you want if the numbers is greater than 9.9 but less than 100?

Also note that you replied to a post posted in July of 2005!

--
Regards,

Peo Sjoblom

Portland, Oregon
 
A

Armor

Most Giga-Hertz systems are between 1.0GHz and 4.0GHz. So, any x.x number
entry is a "GHz" system. The Mega-Hertz system run between 450MHz and
900Mhz, so any xxx number is "MHz" system. If the systems is bigger, a
1200MHz system, then we just type a 1.2GHz system.
Since I will be doing the data entry, I will know which. I just want to get
a littel better speed in the data entry by just typing numbers. I would like
the function to finish the unit desigantor. Just like when the cells are
formated for a "phone number". Automatic parenthesis and hyphens.

Thank You
 
P

Peo Sjoblom

Maybe

=IF(AND(A2>=0.1,A2<=9.9), "GHz",IF(AND(A2>=100,A2<=999),"MHz",""))

--
Regards,

Peo Sjoblom

Portland, Oregon
 
P

Peo Sjoblom

Doh! I forgot to add the values from A2, see Roger's reply

--
Regards,

Peo Sjoblom

Portland, Oregon
 
A

Armor

These are perfect. I thank both of you. These are just what I need.
Again, Thank you very much.

Armor
 
Top