Conditional Rounding Part deux

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I include $x.89 value in the below formula to add $0.05 with the $x.09
& $x.59 value?
 
one way:

=INT((10*A1)+1)/10-0.01+OR(MOD(INT(A1*10)-(INT(A1)*10),5)=0,MOD(INT(A1*10)-(INT(A1)*10),8)=0)*0.05
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same formula one not calculating properly? 2
SUMIF "value if false" not working 2
Scrabble Value calculation for Welsh words 0
How to Shorten a repetitive formula to include more references. 7
How do I set a maximum value (e.g. cap at 200) 6
Array Formula Error 5
subtraction returning incorrect calue 5
Retail Price rounding help needed 1

Back
Top