I am assuming you are trying to round to the nearest 5 on your figures!
so you had an error in your second half of the formula, and the sum statements are unnecessary :-
=ROUND(C5/1.5/5,0)*5*6.5%+(26.25+15.81+1)+(ROUND(C5/1.5/5,0)*5*6.5%+26.25+15.81+1)*19%
This gives the correct result!
Which is the same as :-
=(ROUND(C5/1.5/5,0)*5*6.5%+(26.25+15.81+1))*119%
which both give the result 168.8134
adding
=Round((ROUND(C5/1.5/5,0)*5*6.5%+(26.25+15.81+1))*119%,2)
OR
=ROUND(ROUND(C5/1.5/5,0)*5*6.5%+(26.25+15.81+1)+(ROUND(C5/1.5/5,0)*5*6.5%+26.25+15.81+1)*19%,2)
Gives exactly 168.81 which is what you wanted!
Bookmarks