View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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