can you round a number then use it in another formula

D

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?
 
B

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

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
G

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
 
Top