gleemonex69
New Member
- Joined
- Dec 9, 2010
- Messages
- 37
Good afternoon, Excel gods. I have the following data:
A B C D E
01 Name Amount Liter/ML Amount Fl. Oz
02 Tequila 1 Liter 33.814 Fl. Oz.
03 Gin 750 ML 25.3605 Fl. Oz.
What would be the formula if I want Column D to automatically calculate based on whether Column C says either Liter or ML? Your help is greatly appreciated.
A B C D E
01 Name Amount Liter/ML Amount Fl. Oz
02 Tequila 1 Liter 33.814 Fl. Oz.
03 Gin 750 ML 25.3605 Fl. Oz.
What would be the formula if I want Column D to automatically calculate based on whether Column C says either Liter or ML? Your help is greatly appreciated.
Last edited: