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




"Armor" wrote in message
...
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



On Thu, 28 Jul 2005 21:45:02 -0700, "Freshman"
wrote:

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","")

=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?

Format/Cells/Number/Custom Type: 000000


--ron