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!
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!