Calculation based on Ranges

[Joseph31]

Hello everyone,

I need to make a calculation that return a value based on a percentage.

IE: if percentage is

0%-10% the calc would return a "1"

11%-20& the calc would return a "2"

21%-30% the calc would return a "3"

31%-40% the calc would return a "4"

41%-100% the calc would return a "5"

Can some one show me how to right this -- maybe a case function?

Thank you,

Joseph

[LaRetta]

Hi Joseph, you might try calculation, result is number with:

Case (

Percent > 40 ; 5 ;

Ceiling ( Percent / 10 )

)

or ...

Case (

Percent ≤ 10 ; 1 ;

Percent ≤ 20 ; 2 ;

Percent ≤ 30 ; 3 ;

Percent ≤ 40 ; 4 ;

5 )

Edited October 27, 2009 by Guest
Added alternate calc

[Joseph31]

Thank you --

Edited October 27, 2009 by Guest

[Joseph31]

It works great -- Thank you again