Hi there, I'm a total novice when it comes to Excel and I'm having a little bit of trouble getting this formula right. Any help would be greatly appreciated!
I'm making a jewelry line spreadsheet so cells that are meant for weight calculations, I would like to appear with a "g" for grams (for example "1.29 g"
At the same time, if there is no weight and the cell is equal to 0, I would like for it to appear as a "-"
I was able to achieve both formulas separately, but when I try to combine them I get an error. Does anyone know what the correct formula would be to achieve this?
Thank you in advance!
Bookmarks