Rounding sums in excel

[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.

 

[Max]

Try :

=ROUND(SUM(E2+(E2*F2)),2)

or

=ROUND(SUM(E2+(E2*F2)),1)

 

[C S M]

Thanks a million.

 

[Max]

you're welcome!

cheers
Max

 

[Ron Rosenfeld]

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

 

[C S M]

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

Yes that's it. mucho gracias.

Csm