You might have Excel sheets which deal with mutliple units clubbed as one. If you deal with a number of items, you can figure out how many multiples you need to order on the basis of a single base number, with the help of this simple trick. To do so just carry out the following steps:

o Type the heading in cell 81.

o Type the original/total value in "Row 8" from cell 82 onwards.

o In cell C2, type the formula as, "=INT!82/15) & "-" & RIGHT("OO" & MOD!82,15!.2l".

Name: Displaying number with a base.jpg Views: 47 Size: 27.9 KB

In this formula, the INTII function returns the integer part of the division value. The MODII function returns the remainder value, the RIGHTII function picks two of the right most values, and this value is then concatenated with the ..... sign appearing after the integer value. The result will appear as "12.09"

NOTE: This result cannot be used as a value for mathematical functions. It is for reference only.