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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Peo Sjoblom" wrote in message
...
Maybe

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

--
Regards,

Peo Sjoblom

Portland, Oregon




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

"Peo Sjoblom" wrote:

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