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.

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

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

Another question is how can I show the number "002170" in A2 beside adding a
' in front of the number?

Thanks.

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

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

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

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

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

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

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

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