Simple math equation: rounding of data

[Scorpion Steve]

I have cell ranges that holds % data. the % is formatted to 0 decimal places so shows (for example) 47% when it is actually 47.021111
I need to have a simple equaltion that looks at automated rounding up to the nearest %. A whole number in other words!

Is there a formula to simply say .. Take A1, condense to nearest % and place in B1?

If that formula exists then prorblem solved, I will just insert a new column and hide it afterwards!

Thanks

 

[VoG]

Try

=ROUND(A1,2)

Format as percent to 0 decimal places.

 

[Scorpion Steve]

Amazing, Ive been up all hours working on spreadsheets with ridiculous forulas and have the most simplest one give me grief!
Thanks Vog