Rick, I really appreciate your assistance!!!

I think I'm doing something wrong. I know formulas have to be PERFECTLY
typed or else you'll get an error message. I cut and pasted your formula
into my spreadsheet, but am getting a VALUE error.

Cell A27 holds the text "Lamb Shanks"
Cell B27 is empty (because we're not measuring liquid/mL)
Cell C27 displays 685.0 g. The actual numerical value is something like
684.99992. The cell is Custom Formatted as 0.0 "g"
Cell D27 is where I tried both of the formulas and got errors.

Should I be using IF-THEN in the formula, something like IF there's a
number in B27, display it, otherwise IF there's a number in C27, display it,
otherwise IF there's nothing in either column, display nothing.