Compounded Roundup

[schaferdd]

Assume starting value is in cell A1.
I wish to multiply this figure by 1.01, and round to nearest integer (result in cell B1).
Then, then take this rounded figure result and next multiply by 1.02 (also rounded to nearest integer).
Then, take this rounded figure result and next multiply by 1.03 (also rounded to nearest integer).
Note: final value is in cell B1 and essentially a multiple calculation within the one formula.
Thanks!

 

[DRSteele]

This formula nests the functions as you desired.

=ROUND(1.03*ROUND(1.02*ROUND(1.01*A1,0),0),0)

 

[AhoyNC]

Maybe:

Book1
	A	B
1	107.54	114
Sheet2

Cell Formulas
Range	Formula
B1	B1	=ROUND(ROUND(ROUND(A1*1.01,0)*(1.02),0)*1.03,0)

 

[schaferdd]

Thank you very much; the calculation is working as desired.

 

[DRSteele]

You're most welcome.