Rounding and Multiplying

Sue · Mar 1, 2006

Can I multiply 2 numbers together and have the answer rounded to 0 decimals?

For example:

a1 = 4.25
b1 = 5.25
c1 = 22.31

I want c1 to be rounded to 22 (not just formatted to look like 22 but to
actually round the number).

Thanks,

CLR · Mar 1, 2006

Put this in C1

=ROUND(A1*B1,0)

Vaya con Dios,
Chuck, CABGx3

Sue · Mar 1, 2006

Thank you.
--
Sue

CLR said:
Put this in C1

=ROUND(A1*B1,0)

Vaya con Dios,
Chuck, CABGx3