# Logical test with Text string

#### Nicholas Petti

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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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!

Try something like this

Excel Workbook
ABC
175010253.5
2100010338
Sheet1

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?

The easiest would be a separate column.

Replies
4
Views
431
Replies
1
Views
160
Replies
4
Views
560
Replies
0
Views
132
Replies
1
Views
252

1,203,483
Messages
6,055,678
Members
444,807
Latest member
RustyExcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back