Forum Discussion
bryanmartin
Nov 06, 2019Copper Contributor
Decimal Places in Formulas
When I put a formula into Excel, and the answer is less than 1, it displays "0". I already have the cells set to two decimal places. How can I get this to function correctly? Example: 10 divi...
mathetes
Nov 12, 2019Gold Contributor
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.
bryanmartin
Nov 12, 2019Copper Contributor
Wow, that was easy. Thank you!