Thread: rounding to the nearest Dollar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
H H is offline
external usenet poster
  
Posts: 57
Default rounding to the nearest Dollar
Does anyone know how to set your formula to round to the nearest Dollar

=CONCATENATE(B18*B19*B20)&" - "&B5
Reply With QuoteReply With Quote