9 divide by 2 is 4??

T

timjimbob

New Member
Joined
Apr 27, 2007
Messages
38
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.
Sort by date Sort by votes
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.
Click to expand...

If you are looking for 4.5, simply use:
=9/2
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Excel formula does not return expected result when encountering a cell that includes text in a formula reference
2
Replies
11
Views
579
Joe4
Joe4
J
  • Question
Formula for weekdays of date in another cell
Replies
4
Views
441
Jaxi
J
B
  • Solved
Formula to find exact division
Replies
9
Views
341
lrobbo314
lrobbo314
E
  • Question
Deprecated features and functions?
Replies
5
Views
394
Scott Huish
Scott Huish
P
  • Question
Multi-sheet formulas saving as values
Replies
0
Views
442
philipavery
P

Forum statistics

Threads
1,214,599
Messages
6,120,453
Members
448,967
Latest member
grijken

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top