Rounding sums in excel

  • Thread starter Thread starter C S M
  • Start date Start date
C

C S M

I need some help. Is there a way to make Excel round an =SUM, such has:
=SUM(E2+(E2*F2)), E2 is my cost of a product, F2 is my mark up percentage.
I would like to round the sum to the nickel, but the dime would work fine.

If you know please post, TIA for any and all help.
 
I need some help. Is there a way to make Excel round an =SUM, such has:
=SUM(E2+(E2*F2)), E2 is my cost of a product, F2 is my mark up percentage.
I would like to round the sum to the nickel, but the dime would work fine.

If you know please post, TIA for any and all help.

To round to the nearest nickel:

=ROUND(SUM(E2+(E2*F2))*20,0)/20

The factor 20 is there because a nickel is 1/20th of a dollar


--ron
 
Back
Top