Thread: Reducing digits when multiplying
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johney
 
Posts: n/a
Default Reducing digits when multiplying
A1=1.234
A2=5.678

=ROOUNDDOWN(MOD(A1,1),2)*ROUNDDOWN(MOD(A2,1),2)

Reply With QuoteReply With Quote