Logical test with Text string

This is a discussion on Logical test with Text string within the Excel Questions forums, part of the Question Forums category; Greetings again from the excel noob.
I have a list of spirits, some are 750ml and some are 1 liter. ...

Logical test with Text string

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)

Re: Logical test with Text string

Kind regards,
S.H.A.D.O.-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.