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.
Units in formulae
Post Reply
1 post
• Page 1 of 1
Return to “PlanMaker 2021 for Windows”
Jump to
- Office
- ↳ SoftMaker Office 2021 for Windows
- ↳ SoftMaker Office 2021 for Windows (General)
- ↳ TextMaker 2021 for Windows
- ↳ PlanMaker 2021 for Windows
- ↳ Presentations 2021 for Windows
- ↳ BasicMaker 2021 for Windows
- ↳ SoftMaker Office 2021 for Mac
- ↳ SoftMaker Office 2021 for Mac (General)
- ↳ TextMaker 2021 for Mac
- ↳ PlanMaker 2021 for Mac
- ↳ Presentations 2021 for Mac
- ↳ SoftMaker Office 2021 for Linux
- ↳ SoftMaker Office 2021 for Linux (General)
- ↳ TextMaker 2021 for Linux
- ↳ PlanMaker 2021 for Linux
- ↳ Presentations 2021 for Linux
- ↳ SoftMaker Office 2018 for Windows
- ↳ SoftMaker Office 2018 for Windows (General)
- ↳ TextMaker 2018 for Windows
- ↳ PlanMaker 2018 for Windows
- ↳ Presentations 2018 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2018 for Windows
- ↳ SoftMaker Office 2018 for Mac
- ↳ SoftMaker Office 2018 for Mac (General)
- ↳ TextMaker 2018 for Mac
- ↳ PlanMaker 2018 for Mac
- ↳ Presentations 2018 for Mac
- ↳ SoftMaker Office 2018 for Linux
- ↳ SoftMaker Office 2018 for Linux (General)
- ↳ TextMaker 2018 for Linux
- ↳ PlanMaker 2018 for Linux
- ↳ Presentations 2018 for Linux
- ↳ SoftMaker Office HD for Android
- ↳ SoftMaker Office HD for Android (General)
- ↳ TextMaker HD
- ↳ PlanMaker HD
- ↳ Presentations HD
- ↳ FreeOffice 2018 for Windows
- ↳ SoftMaker FreeOffice 2018 for Windows (General)
- ↳ FreeOffice TextMaker 2018 for Windows
- ↳ FreeOffice PlanMaker 2018 for Windows
- ↳ FreeOffice Presentations 2018 for Windows
- ↳ FreeOffice 2018 for Mac
- ↳ SoftMaker FreeOffice 2018 for Mac (General)
- ↳ FreeOffice TextMaker 2018 for Mac
- ↳ FreeOffice PlanMaker 2018 for Mac
- ↳ FreeOffice Presentations 2018 for Mac
- ↳ FreeOffice 2018 for Linux
- ↳ FreeOffice 2018 for Linux (General)
- ↳ FreeOffice TextMaker 2018 for Linux
- ↳ FreeOffice PlanMaker 2018 for Linux
- ↳ FreeOffice Presentations 2018 for Linux
- ↳ FlexiPDF 2019 for Windows
- ↳ FreePDF for Windows
- ↳ FreePDF for Windows
- Miscellaneous
- ↳ SoftMaker Fonts
- ↳ Water Cooler