Need help with Formula

D

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.

:)
 
B

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
 
O

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ö
 
D

duffy75

olasa said:
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
Click to expand...

Thanks buddy!!!

:
 
Top