LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel is rounding up my formula result

Why not just make this easy for yourself? Use:
=round(D2/1.1,2)

"Mike H" wrote:

Have a look at help for quotient, it's doing exactly what it's designed to do
i.e. return
the interger portion of a division.

Try

=419/1.1
both of the above could be cell reference to those 2 values
=A1/B1

Mike
"bnkrpony" wrote:

I am new to this whole process and am spending too much time trying to
determine how to fix my problem. Any help would be greatly appreciated. I am
simply trying to divide a number by another and obtain the exact result of
such expanded to two decimal places. For instance 419.00 divided by 1.10
equals 380.91. However the formula I am using =QUOTIENT(D2,1.1) produces a
result of 380.00 instead. Note that the formula will not hold my entry of
1.10 either. Any suggestions?
--
bnkrpony



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent EXCEL from rounding the result of a calculation elusiverunner Excel Discussion (Misc queries) 3 January 9th 08 08:38 AM
Rounding up the result of an IF function donnaK Excel Worksheet Functions 3 December 8th 05 10:15 PM
Rounding a formula result to read thousands from millions. R Champ Excel Worksheet Functions 2 August 5th 05 08:31 PM
stop excel from rounding a result Hazeldean Excel Worksheet Functions 3 May 13th 05 10:42 PM
Rounding up the result cubus Excel Worksheet Functions 13 January 14th 05 08:41 PM


All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"