Convert numbers with decimals as whole numbers to combine with SWITCH function

[jarrgonn]

Hello.

I'm trying to convert a decimal number to a whole number so that I can convert that whole number to its actual value in text.

I attached a sample file. On the file, it indicates the Level [in numbers] and Text Value [in words] - but I wouldn't want it to show tha table anywhere on the file, thus I thought of combining MROUND and SWITCH formulae. But I cant get around it.

[Pete_UK]

Try this in C2:

=CHOOSE(ROUND(B2,0),"Minimal","Low","Moderate","High")

then copy down. You don't need the table.

Hope this helps.

Pete

[Richard Buttrey]

Are all your averages <=4 ?

[jarrgonn]

Wow!

Thanks Pete! This is much shorter and less complicated! What I used was still the SWITCH + MROUND formulae when I found out that I was actually ordering it the right way. CHOOSE is a great formula.

Again, thanks Pete.

[jarrgonn]

Yeah, maxed at 4 since there are only 4 text values.