can you round a number then use it in another formula

[Darice Bloom]

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?

 

[PCLIVE]

Works for me.

What is your formula and how are you rounding?

Regards,
Paul

 

[Brad]

assuming the number is in cell C15

and the calculation you want is in D15. (cell location really doesn't make
a difference)
=round(c15,1)*15-2

This formula will round cell c15 to 1 decimal place then multiply it by 15
and then subtract two.....

 

[Sandy Mann]

I assume that you are not Rounding the number but rather formatting the cell
to show only integers. Use the formula:

=ROUND(Your Formula, 0)

This will change the actual result of your formula into an integer.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gord Dibben]

=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