Excel Convert ounces to grams via dropdown list in Excel

Joined
Feb 19, 2015
Messages
2
Reaction score
0
In column c I have a drop list for ounces or grams.

Also in column c are entry s example Oils 60 ounces, presevervatives 4 ounces.

If I want to be more accurate I select grams from the list and I want the ounces converted to grams .......or visa versa

Can anyone assist please :) A copy of the sheet was uploaded
 

Attachments

  • test.zip
    11.5 KB · Views: 175

muckshifter

I'm not weird, I'm a limited edition.
Moderator
Joined
Mar 5, 2002
Messages
25,735
Reaction score
1,204
s'been a long time since I needed to use Exhell for anything, however, I do remember that one should use the 'convert' function ... and I found this;


:user:
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top