Thread: rounding a number with a formula already in cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 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,


Reply With QuoteReply With Quote