# 9 divide by 2 is 4??

#### timjimbob

##### New Member
Formula in cell is "=QUOTIENT(9,2)" returns 4.000. Can't change its mind.
tried repair. Office 2000 (Excel) running on XP.

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

#### Joe4

It does exactly what it is supposed to do. If you check out the QUOTIENT function in Excel help, you will see the following:

Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.

If you are looking for 4.5, simply use:
=9/2

Replies
2
Views
253
Replies
0
Views
102
Replies
5
Views
156
Replies
1
Views
176
Replies
6
Views
429

1,186,826
Messages
5,960,020
Members
438,458
Latest member
manojkumarat1999

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back