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