Forum Discussion
Decimal Places in Formulas
Hi, thanks for your reply. The formula I'm using is =QUOTIENT(C4,B4)
In the B4 cell I have the number 50, and in C4 I have the number 10.
10 divided by 50 is coming up 0.00 instead of 0.20.
In the attached screen shot, you can see that I have the decimal place set to hundredths.
bryanmartin Here's what Excel Help says about the Quotient function.
The fact is you're making this more difficult than it needs to be. The formula for division is far simpler. In this case it would simply be =C4/D4 and you'd see the result you're looking for (so long as you're formatted for decimal places).
For what it's worth, the basic math operations, addition, subtraction, multiplication and division, do not need to be accomplished with Functions. The operators are +, -, *, and / with multiplication's use of the asterisk the only one that we didn't learn in grade school. The functions are indeed powerful, but generally do more than basic math.
Wow, that was easy. Thank you!