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

Armor

"Roger Govier" wrote:

Hi

Try
=IF(AND(A2=0.1, A2<=9.9), $A$2&" GHz",A$2$&" MHz")

--
Regards

Roger Govier


"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