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

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, 200916 yr by Guest
Added alternate calc

Thank you --

Edited October 27, 200916 yr by Guest

It works great -- Thank you again