ROUND formula, Need only integer part

[elunicotomas]

Hi there, this is my first post, so I'll try to be as clear as I can.

I have this results of a survey and I have to do the averages.

The original results goes from "Extremely Dissatisfied" to "Extremely Satisfied", with a bunch of nested IFs I converted this results to a scale from 0 to 5, and then I got the average from this scale (for each question of the survey).

Now I´m trying to convert this scale of numbers back to the original scale (from "Extremely Dissatisfied" to "Extremely Satisfied"). I'm trying to do this, with a couple of IFs (again). Everything goes fine, the thing is that this formula, for converting the number scale to the original scale, only accepts numbers from 0 to 5, and from the average I got float numbers (i.e., 1.9, 2.5, etc) so I'm getting bad results. I try using the ROUND formula but is the same as using the "not rounded" numbers. I re-entered the averages by rounding them manually and is working fine, my question is: how can I do this with a formula?

I've attached a little part of the sheet so you can see what I mean.

Thanks!

[pjwhitfield]

Your Round should be to zero decimals not 1, it just looks right because the cell is formatted to show 0 decimals but is still storing 2.9 etc

=Round(C26,0)

[pjwhitfield]

ps you shouldnt need to use IFs to convert back to the scale, use a vlookup

[Glenn Kennedy]

I'm not entirely sure if I've picked you up correctly... but have a look at this.

[elunicotomas]

Your Round should be to zero decimals not 1, it just looks right because the cell is formatted to show 0 decimals but is still storing 2.9 etc

=Round(C26,0)

Thanks! I didn't see that

I'm not entirely sure if I've picked you up correctly... but have a look at this.

Yep, that worked better than the Ifs