Thread: Conditional Rounding Part deux
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YK YK is offline
external usenet poster
  
Posts: 8
Default Conditional Rounding Part deux
How do I include $x.89 value in the below formula to add $0.05 with the $x.09
& $x.59 value?

=INT((10*A1)+1)/10-0.01+(MOD(INT(A1*10)-(INT(A1)*10),5)=0)*0.05
Reply With QuoteReply With Quote