View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Can I round prices to end in .95?

Hi,

Try

=INT(A1)+0.95

Mike

"Tire Guy" wrote:

I'm preparing a business price list. It reads a cell from my working cost
sheets.
On the price page can I round prices to end in .95?