Units in formulae

Post Reply
Posts: 4
Joined: Thu Nov 17, 2011 11:59 pm

Units in formulae

Post by noteven47 » Thu Aug 27, 2020 11:16 pm

Is there a way to retain units when a cell is operated on using a formula?
E.g. A1 contains total mass of coins; could be entered in the cell as 473.94g;
B1 contains total number of coins, say 52.
C1 has the formula to calculate the average mass per coin, =A1/B1 but, if either cell contains anything other than the numbers for the calculation, the units are ignored or else an error is indicated.
I know that the scientifically preferable way in a table is to have the units in the table heading but I was thinking of incorporating a few cells of spreadsheet into a document as part of a sentence to illustrate a point.

Post Reply

Return to “PlanMaker 2021 for Windows”