Share via

Help With adding micro grams and grams in excel

Anonymous
2018-06-17T12:23:06+00:00

Been trying to find a way to add the fats (cells K4-O4) to total fat (cell J4), but I'm having trouble getting it to distinguish between the 1 gram(g) in cell L4 and micro grams(mg) in cells N4 and O4 it’s not recognising the gram as a full gram but rather a micro gram, can anyone help? is this even possible? Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-06-17T12:43:42+00:00

    1g = 1000 mg

    the custom format does not convert units.

    You have to divide the MG columns by 1000 in the sum formula, ie

    j4= k4 + l4 + m4 + n4/1000 + o4/1000

    or

    =sum(k4, l4, m4, n4/1000, o4/1000)

    0 comments