Divide and NOT Round in one formula

[1crazycajun]

Hello

First let me say I have tried for hours trying to figure how to this with no luck..

I have a 3 Columns .....Ex: (Col. D)Total Cost ,(Col. F) # of Units and (Col. K) Cost per unit..

In E.. I have.. $121,538.00 ,In F....900 , to get cost per unit I know to divide which would make the formula ..... =QUOTIENT(D7,F7) which equals 135.00. But using that formula rounds it and I need it to be accurate, which is really $135.04. And I need that number to be in Column K...

I Have tried using the Quotient & Round together but it doesn't work...

Any advice would be appreciated.

[CheshireCat]

How about using:

Please Login or Register  to view this content.

and formatting the cell as Currency?

[1crazycajun]

Well If I don't feel like a complete idiot......... so simple geezzzzzz

Thank you very much Cheshirecat