ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   using round to increase decimal ? (https://www.excelbanter.com/excel-programming/310650-re-using-round-increase-decimal.html)

Tom Ogilvy

using round to increase decimal ?
 
=ROUND(B2,2) with 422 in B2 produces 422.

You need to check the assignment closer and make sure you understand what is
being asked.

=Round(B2,-2) with 422 in B2 produces 400

perhaps that is what they are asking.

--
Regards,
Tom Ogilvy

"rania" wrote in message
...
fhi

I would like to increase decimal using round function instead of Format

..
for example Ihave 422, and would like 422.00 to be schown.

I know that it does not make since because of the function of round.
but I have this in an excercice .

Thanks





All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com