Need help with Formula

[duffy75]

Hi people, i am having a little trouble with a formula that i am trying
to use and would appreciate any help.

I am trying to divide a particular cell by 30 to get daily dollar
average.

In the cell that i would like the average to appear in, i used the
following formula...

"=(D25/30)"

My problem is two fold:

1. The result it is giving me, is not being expressed as a dollar
amount; for instance, i need the result to display as $128.80, instead
it is being displayed as "128.80".

2. It is not rounding up to a traditional dollar amount, instead it is
giving me a number like "128.803333333"

Any help is greatly appreciated.

 

[Bernie Deitrick]

Duffy,

Format the cell for currency, with 2 decimal places. And, possibly, change your formula to

=ROUND(D25/30,2)

Note that there are some accuracy implications to rounding the value.

HTH,
Bernie
MS Excel MVP

 

[olasa]

First
=ROUND(D25/30,2)
128.803333333 ---> 128.80

Second
Right click on the result
Format Cells...> and then select Tab Number > and Currency ... I thin
you will manage from here.

Good luck
Ola Sandströ

 

[duffy75]

First
=ROUND(D25/30,2)
128.803333333 ---> 128.80

Second
Right click on the result
Format Cells...> and then select Tab Number > and Currency ... I thin
you will manage from here.

Good luck
Ola Sandström

Thanks buddy!!!

:

 

[olasa]

Thanks for the feedback
Ol