So I have a document where I am calculating the cost of goods of a product. I break down the cost of ingredients but I was wondering if there is a way to add “per g” to the end of the currency. Lets say chocolate costs $10.00 for 10oz and I need to know how much each gram costs. I do the math and find out it is $0.04 per gram, but is there a way to make it say “$0.04/g” in my cells? I have tried just adding /g to the end in format cells but that doesn’t work, It just changes it to a number.
See attached file… Adding /g is no working completion, use “/g” instead.
CustomizedFormatPerGram.ods (12.6 KB)
.
Cheers
2 Likes
Thank you so much!!! I could not figure it out! THANK YOU for being so helpful!
(OT? Just opinionated?)
A spreadsheet that treats numeric values per column as designators (representations) of a common special semantics for input/output should not work with a specific NumberFormat. The right place to inform about the semantics is the column header.
When using formats, you will always get TRUE if you compare 1.00JPY with 1.00USD. Strange? Yes.
It is not a good way to implant all subjects into only 1 cell as a busy hieroglyphic. The good way is to difference those in separate cells with TEXT or NUMERAL. Try this:
0_LibreOffice-CALC_physikalische Größen u Einheiten u FormelZeichen_iN ARBEiT-v0000.ods (17.5 KB)
1 Like
In my file, have a special look onto the expression „=(x)LOOKUP()“ after the yellow cell „before“ is chosen. That file is only to test and adapt and so on.
I am using the area [AA:AZ] to simplyfy the chained calculations and to insert all listings which i can chose. So it’s easier to find any mistake or fault.
It is a good thing to be able to format cells as one needs, without changing the cell’s actual content for the calculation, and without introducing more auxulliary cells. Different goals require different approaches.
2 Likes