# 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. ...

1. ## 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)

Hopefully that makes sense.

2. ## Re: Logical test with Text string

Do you mean something like this:

Code:
`=CONCATENATE(A1," = ",IF(A1=750,A1*25.53,IF(A1<>750,A1*33.8)))`
Change A1 to suit.

I hope this helps!

3. ## Re: Logical test with Text string

Try something like this

Sheet1

 A B C 1 750 10 253.5 2 1000 10 338

 Cell Formula C1 =IF(A1=750,B1*25.35,B1*33.8) C2 =IF(A2=750,B2*25.35,B2*33.8)

Excel tables to the web >> Excel Jeanie HTML 4

4. ## Re: Logical test with Text string

Thank you but will this work if for instance what is in the cell is something like Bulleit Rye 750? Or do I have to create a separate column to list the 750 ml and liters?

5. ## Re: Logical test with Text string

The easiest would be a separate column.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•