Another option is "Precision as displayed", but I wouldn't recommend it.
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=ROUND(A1,0)*B1 entered in C1 will round A1 but not B1

=ROUND(A1*B1,0) will round your result in C1


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 12:26:03 -0700, Darice Bloom <Darice
wrote:

I want to use a rounded number in another formula but it uses the decimal
number instead.

How can I tell it to use the rounded number in the formula?