![]() |
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