Rounding Again
 

=E15/E9 Where E15 is the total price of 12.50 and E9 is
the common denominator of 52 or 26 or 12. In this formula
E15/E9 I get 0.240384615384615384615384615384615 and the
solution on my spreadsheet is .24. If you multiply .24X52
you get 12.48 NOT 12.50, as is true with .24 X 26 and so
on for each pay period. My Question is, how can
incorporate the ROUND function into my formulas
Ex: E15/E9round(??????)
Or =if(??????)

Thank You,

Rounding Again
 

=round(E15/E9,2)

-----Original Message-----
=E15/E9 Where E15 is the total price of 12.50 and E9 is
the common denominator of 52 or 26 or 12. In this formula
E15/E9 I get 0.240384615384615384615384615384615 and the
solution on my spreadsheet is .24. If you multiply .24X52
you get 12.48 NOT 12.50, as is true with .24 X 26 and so
on for each pay period. My Question is, how can
incorporate the ROUND function into my formulas
Ex: E15/E9round(??????)
Or =if(??????)

Thank You,

.