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.

=ROUND(your formula,-2)

"texasdutch" wrote:

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.

Suppose the formula is =PV(bla, bla, ......)
Warp it in a ROUND function
=ROUND(PV(bla, bla, ......), -2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"texasdutch" wrote in message
...
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.

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

"texasdutch" wrote in message
...
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.

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

"texasdutch" wrote in message

...



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 -

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

On Apr 5, 4:38 pm, "Susan" wrote:
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

"texasdutch" wrote in message

...

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 -

ooooooooooh.
aaaaaaaaaah.
<applause
thank you!
:)
(i'd never used that formula before, so i didn't even know how to test
it.)
susan



On Apr 5, 12:58 pm, "Pete_UK" wrote:
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

On Apr 5, 4:38 pm, "Susan" wrote:



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

"texasdutch" wrote in message

...

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 -