Number range calculation

[schooltechie]

I am trying to set up the following calculation. I am not sure how to do the range for greater than/equal to 4 and less than/equal to 85. Any help would be appreciated. Thanks.

Case(BMI >= "4", "Below", BMI <> "5-85", "Normal", BMI <= "86", "Over")

[RalphL]

Try the following:

Case ( BMI >= 86, "Over",

BMI >= 5, "Normal",

"Below")

[LiveOak]

You didn't state what you are trying to do. Not knowing if you calculation is correct or not, I'll take a guess:

Case(

BMI <= 4, "Below",

BMI <= 85, "Normal",

"Over"

)

Case statements evaluate in order, taking the first match. You might want to state in English what your calculation should do so I can make sure this is what you want.

-bd

[schooltechie]

What I'm trying to achieve is a statement in the BMI Result field of "Below", "Normal" or "Over" according to the number in the BMI field. "Below" would be a BMI less than/equal to 4; "Normal would be a BMI greater than/equal to 5, but less than/equal to 85; and "Over" would be anything greater than/equal to 86. Does that help clarify the calculation? Thanks!

[RalphL]

That is what either of the 2 calculations presented do. Two ways of doing the same thing.