Excel is rounding up my formula result
 

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

Excel is rounding up my formula result
 

The function you are using will only return the integer portion of the
answer. That's just what it does. A better way to get the desired result
would be =D2/1.1. Note that Excel drops trailing zeros to save space so you
won't see it even if you enter it. 1.1 is the same as 1.10. To have your
results show two decimals format the cell as a number with two decimal places.

HTH

LSquared

"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

Excel is rounding up my formula result
 

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

Excel is rounding up my formula result
 

Thank you soooo much! Your suggestion worked great!
--
bnkrpony


"LSquared" wrote:

The function you are using will only return the integer portion of the
answer. That's just what it does. A better way to get the desired result
would be =D2/1.1. Note that Excel drops trailing zeros to save space so you
won't see it even if you enter it. 1.1 is the same as 1.10. To have your
results show two decimals format the cell as a number with two decimal places.

HTH

LSquared

"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

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