How do I round a formula generated number

[Guest]

When creating a financial proforma I calculate monthly revenues that need to
be rounded to nearest $100. How can I combine the formula and [round]
function in the same cell.

 

[Guest]

=ROUND(your formula,-2)

 

[Bernard Liengme]

Suppose the formula is =PV(bla, bla, ......)
Warp it in a ROUND function
=ROUND(PV(bla, bla, ......), -2)
best wishes

 

[David Biddulph]

=ROUND(your_formula,-2)

 

[Susan]

could this type of thing be used to avoid rounding errors?
in some spreadsheets that my boss uses every month, the calculations
produce numbers with long decimals, i.e.,
268.30293302
i have it formatted to two decimal places, which shows 268.30;
however, over time rounding errors occur because those extra decimals
add up & eventually add a .01 to the total.
would using =round fix that???
thanks!
susan

=ROUND(your_formula,-2)
--
David Biddulph

When creating a financial proforma I calculate monthly revenues that need
to
be rounded to nearest $100. How can I combine the formula and [round]
function in the same cell.- Hide quoted text -

- Show quoted text -

 

[Pete_UK]

Simple test - put this formula in A1

=4/3

and this in B1

=ROUND(A1,2)

you should get 1.3333 etc in A1 (depending on the formatting of the
cell) and 1.33 in B1. Copy these down into A2:B3, and then in A4 add
this formula;

=SUM(A1:A3)

and copy this to B4. Do you see any difference?

Pete

could this type of thing be used to avoid rounding errors?
in some spreadsheets that my boss uses every month, the calculations
produce numbers with long decimals, i.e.,
268.30293302
i have it formatted to two decimal places, which shows 268.30;
however, over time rounding errors occur because those extra decimals
add up & eventually add a .01 to the total.
would using =round fix that???
thanks!
susan

=ROUND(your_formula,-2)

news:[email protected]...

When creating a financial proforma I calculate monthly revenues that need
to
be rounded to nearest $100. How can I combine the formula and [round]
function in the same cell.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[Susan]

ooooooooooh.
aaaaaaaaaah.
<applause>
thank you!

(i'd never used that formula before, so i didn't even know how to test
it.)
susan

Simple test - put this formula in A1

=4/3

and this in B1

=ROUND(A1,2)

you should get 1.3333 etc in A1 (depending on the formatting of the
cell) and 1.33 in B1. Copy these down into A2:B3, and then in A4 add
this formula;

=SUM(A1:A3)

and copy this to B4. Do you see any difference?

Pete

could this type of thing be used to avoid rounding errors?
in some spreadsheets that my boss uses every month, the calculations
produce numbers with long decimals, i.e.,
268.30293302
i have it formatted to two decimal places, which shows 268.30;
however, over time rounding errors occur because those extra decimals
add up & eventually add a .01 to the total.
would using =round fix that???
thanks!
susan

On Apr 5, 10:26 am, "David Biddulph" <groups [at] biddulph.org.uk>
wrote:

=ROUND(your_formula,-2)
--
David Biddulph

When creating a financial proforma I calculate monthly revenues that need
to
be rounded to nearest $100. How can I combine the formula and [round]
function in the same cell.- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -