Oct 22 2019 04:10 AM
Hi
As can be seen in the attachment, I have the display set to currency and to two decimal places but the values show as .00 instead, such as 10/3 should read 3.33 but displays 3.00. So, how can I get the two decimal places to show the actual values rather than zeros.
Thanks.
R
Oct 22 2019 05:21 AM
QUOTIENT returns the integer portion of a division. The decimal portion will never be included in the returned value.
Oct 23 2019 05:07 AM
Oct 23 2019 05:19 AM
SolutionOct 23 2019 07:56 AM
Oct 25 2019 07:21 AM
'Relatively new' is, by definition, a relative term! I found a list of functions that indicates that QUOTIENT existed and was not newly introduced in 2010. Like you, I only came across the function much later and it took a while to realise that it performs an integer divide. Now it is a regular part of my repertoire used to unpivot crosstab tables and arrays. Used with a base 1 index k, the formulas
= 1 + QUOTIENT( k-1, n )
= 1 + MOD( k-1, n )
provide row and column indices for the 2D lookup.
Oct 23 2019 05:19 AM
Solution