Nicholas Petti
New Member
- Joined
- Mar 25, 2013
- Messages
- 11
Greetings again from the excel noob.
I have a list of spirits, some are 750ml and some are 1 liter. I want a logical test that returns a price in ounces. Something along the lines of IF(cell contains 750, return contents of cell w/price*25.35, if not return contents of cell with price*33.8)
Hopefully that makes sense.
Thanks in advance
I have a list of spirits, some are 750ml and some are 1 liter. I want a logical test that returns a price in ounces. Something along the lines of IF(cell contains 750, return contents of cell w/price*25.35, if not return contents of cell with price*33.8)
Hopefully that makes sense.
Thanks in advance