ExcelBanter - rounding a number with a formula already in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - rounding a number with a formula already in cell (https://www.excelbanter.com/excel-worksheet-functions/167862-rounding-number-formula-already-cell.html)

CIW

rounding a number with a formula already in cell

I want to round a number after I apply a percentage to it--for example:

=F11*1.02, then round the number to the nearest 100.

Is this possible?

Thanks,

Peo Sjoblom

rounding a number with a formula already in cell

=ROUND(F11*1.02,-2)

--

Regards,

Peo Sjoblom

"CIW" wrote in message
...
I want to round a number after I apply a percentage to it--for example:

=F11*1.02, then round the number to the nearest 100.

Is this possible?

Thanks,

All times are GMT +1. The time now is 03:27 PM.