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
|