Thread: Retail Pricing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Retail Pricing
This formula works as well:
=ROUNDDOWN(A1,0)-0.01
.... where A1 holds the 2.01 entry.

Reply With QuoteReply With Quote