Rounding to an integer

[phil133]

Hi. I would like a formula for the following.
To the next upwards integer but with a condition the integer is 2% larger.
An example to explain

[TABLE="width: 500"]
<tbody>[TR]
[TD]80.2[/TD]
[TD]82[/TD]
[/TR]
[TR]
[TD]81.11[/TD]
[TD]83[/TD]
[/TR]
[TR]
[TD]83.4[/TD]
[TD]86[/TD]
[/TR]
</tbody>[/TABLE]

80.2*1.02=81.8 to 82
81.11*1.02=82.7 to 83
83.4*1.02=85.06 to 86

Thanks for any help!

 

[gaz_chops]

Try

=ROUNDUP(A1*1.02,0)

 

[phil133]

Thanks

 

[gaz_chops]

You're welcome.