Thread: Round amount to nearest $10 after other formula calc. in same cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Round amount to nearest $10 after other formula calc. in same cell
Or to aviod the Analysis Tool Pack

=Round(A1*10%,-1)

hth RES
Reply With QuoteReply With Quote