Using the ROUND function

[paulstan]

Hi

I am trying to round numbers and, in the whole have been successful.

Examples:
7.20 rounds to 7
7.58 rounds to 8
9.14 rounds to 9
1.78 rounds to 2

which is exactly what I want. I need to round up or down dependent on the decimals being lower/greater than 0.50

However, I seem to have a problem with just one permutation, that being if the number is less than 0.50 - this rounds down to 0, but I would need this number to round to 1. I can't use ROUNDUP as this would affect everything else. Is there anything I can add to the function to ensure that if the number is less than 0.50 it rounds up to 1?

Many thanks for taking the time to read this.

Regards

Paul

 

[Gerald Higgins]

Well you could use something like this

=if(A1<.5,1,round(a1,0))

 

[paulstan]

Well you could use something like this

=if(A1<.5,1,round(a1,0))

Gerald,

At first glance that looks about what I'm looking for. Will try it out tomorrow (workbook at work), so I will thank you in advance for your help.

Regards

Paul