How do I round a formula generated number

T

texasdutch

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.
 
B

Bernard Liengme

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

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

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)
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 -
 
S

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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top