If Formula using Greater than / Less than
 

My formula is listed below. I would like the formula to look at cell f2 and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9 but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

Try
=IF(F2<=3,1,IF(AND(F23,F2<=6),2,IF(AND(F26,F2<=9 ),3,4)))

"crmulle" wrote:

My formula is listed below. I would like the formula to look at cell f2 and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9 but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

Thank you so much...it worked!

"Sheeloo" wrote:

Try
=IF(F2<=3,1,IF(AND(F23,F2<=6),2,IF(AND(F26,F2<=9 ),3,4)))

"crmulle" wrote:

My formula is listed below. I would like the formula to look at cell f2 and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9 but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

You don't need any IFs:

=1+ROUNDDOWN((F2-0.5)/3,0)

--
Gary''s Student - gsnu200828


"crmulle" wrote:

My formula is listed below. I would like the formula to look at cell f2 and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9 but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

But you don't need to test for F23 when you've already taken out those
where F2<=3, and you don't need to test for F26 when you've already taken
out those where F2<=6.
=IF(F2<=3,1,IF(AND(F23,F2<=6),2,IF(AND(F26,F2<=9 ),3,4))) can be simplified
to
=IF(F2<=3,1,IF(F2<=6,2,IF(F2<=9,3,4)))
--
David Biddulph

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Try
=IF(F2<=3,1,IF(AND(F23,F2<=6),2,IF(AND(F26,F2<=9 ),3,4)))

"crmulle" wrote:

My formula is listed below. I would like the formula to look at cell f2
and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9
but
=12 than 4. The formula is not working and I know it has something to
do
with my logical test but i am not able to figure it out...any help would
be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

Hi Carolyn,

The previous post will work fine but infact there is no need to use the AND
function at all.

Try: =IF(F2<=3,1,IF(F2<=6,2,IF(F2<=9,3,4)))

Now this will return a value of 1 for all blank (or empty cells), to avoid
this use:

=IF(ISBLANK(F2),"",IF(F2<=3,1,IF(F2<=6,2,IF(F2<=9, 3,4))))

Good look.

Danny

"crmulle" wrote in message
...
My formula is listed below. I would like the formula to look at cell f2
and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9
but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would
be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

Thank you!

"Dan R" wrote:

Hi Carolyn,

The previous post will work fine but infact there is no need to use the AND
function at all.

Try: =IF(F2<=3,1,IF(F2<=6,2,IF(F2<=9,3,4)))

Now this will return a value of 1 for all blank (or empty cells), to avoid
this use:

=IF(ISBLANK(F2),"",IF(F2<=3,1,IF(F2<=6,2,IF(F2<=9, 3,4))))

Good look.

Danny

"crmulle" wrote in message
...
My formula is listed below. I would like the formula to look at cell f2
and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9
but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would
be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

Thank you

"Gary''s Student" wrote:

You don't need any IFs:

=1+ROUNDDOWN((F2-0.5)/3,0)

--
Gary''s Student - gsnu200828


"crmulle" wrote:

My formula is listed below. I would like the formula to look at cell f2 and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9 but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

If Formula using Greater than / Less than
 

Thank you.

"David Biddulph" wrote:

But you don't need to test for F23 when you've already taken out those
where F2<=3, and you don't need to test for F26 when you've already taken
out those where F2<=6.
=IF(F2<=3,1,IF(AND(F23,F2<=6),2,IF(AND(F26,F2<=9 ),3,4))) can be simplified
to
=IF(F2<=3,1,IF(F2<=6,2,IF(F2<=9,3,4)))
--
David Biddulph

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Try
=IF(F2<=3,1,IF(AND(F23,F2<=6),2,IF(AND(F26,F2<=9 ),3,4)))

"crmulle" wrote:

My formula is listed below. I would like the formula to look at cell f2
and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9
but
=12 than 4. The formula is not working and I know it has something to
do
with my logical test but i am not able to figure it out...any help would
be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn