Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent EXCEL from rounding the result of a calculation | Excel Discussion (Misc queries) | |||
Rounding up the result of an IF function | Excel Worksheet Functions | |||
Rounding a formula result to read thousands from millions. | Excel Worksheet Functions | |||
stop excel from rounding a result | Excel Worksheet Functions | |||
Rounding up the result | Excel Worksheet Functions |