How do I enter formula for < or numbers.
I just noticed the max criteria of 6 (I slow down when it gets late...sheesh):
Consequently, these would be appropriate:
=MIN(6,FLOOR(MAX(($A$1-35)/5,0),1))
or
=MIN(6,MAX(INT(($A$1-35)/5),0))
***********
Regards,
Ron
"Ron Coderre" wrote:
Actually, these are shorter methods:
=MAX(INT(($A$1-35)/5),0)
or
=FLOOR(MAX(($A$1-35)/5,0),1)
***********
Regards,
Ron
"Ron Coderre" wrote:
Try this:
=IF((A1=40),FLOOR((A1-40)/5,1)+1,0)
Does that help?
***********
Regards,
Ron
"Betty P." wrote:
I am trying to enter a formula in a worksheet. I want the formula to do the
following: IF A1=40 then enter 1, if less that 40 enter 0, OR IF A1=45 enter
2, if less that 45 but more than 40 enter 1, OR IF A1=50 enter 3, if less
than 50 but more than 45 enter 2......and so on until the final one reads if
65 or greater enter 6.
Please help.....
|