Thanks, I didn't know you could nest "round".

"John C" wrote:

Assuming A1 is your value of 5.55556, and B1=1.09
C1: =ROUND(ROUND(A1,2)*B1,2)

or, if the 1.09 is static, you could hardcode it in like so:
=ROUND(ROUND(A1,2)*1.09,2)
--
John C


"pgarcia" wrote:

Hello all,
Cell A1= 5.5556, I need to round that number (5.56) then multiply by 1.09
and round again. I'm looking for just one formula to do all three. Thanks