Thread: formula to roundup to the nearest 9
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
  
Posts: 623
Default formula to roundup to the nearest 9
Try

=roundup(a1*1.5*1.14,-1)-1

--
Regards,
Fred


"susiegirl" wrote in message
...
I have marked up prices with 50% plus 14% vat and then need to round up to
the nearest nine. Please help.
Many thanks
Warm regards
Sue


Reply With QuoteReply With Quote