# If cell contains text then calculate - What is the formula?

#### NNOG28

##### New Member
 column/row A B C D 1 Item Unit or pallet unit per case Total Case 2 Apple 50 2 25 (=50/2) 3 Apple on a pallet 4 2 8 (=4*2) 4 Orange 8 4 2 (=8/4) 5 Orange on a pallet 15 4 60 (=15*4)

<tbody>
</tbody>

I want to use if formula to calculate for column D. what should the formula be?

I tried this but it didn't work.

=IF(A2="*"&"pallet"&"*",B2*C2,B2/C2)

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### Fluff

##### MrExcel MVP, Moderator
=IF(ISNUMBER(SEARCH("pallet",A2)),B2*C2,B2/C2)

#### James006

##### Well-known Member
Hello,

When it comes to designing your worksheet ...

You should make your life easier ...and have nothing but Apples and Oranges in your Items Column ...

and insert a Type Column ... with say P for Pallet and nothing for Unit ...

HTH

#### DanteAmor

##### Well-known Member
Try:

=IFERROR(VLOOKUP("*pallet*",A2:B2,2,0)*C2,B2/C2)

#### NNOG28

##### New Member

=IF(ISNUMBER(SEARCH("pallet",A2)),B2*C2,B2/C2)

This works perfectly for me.. thank you so much

#### NNOG28

##### New Member
Hello,

When it comes to designing your worksheet ...

You should make your life easier ...and have nothing but Apples and Oranges in your Items Column ...

and insert a Type Column ... with say P for Pallet and nothing for Unit ...

HTH

This is a good idea to try to make it simpler when it comes to our own spreadsheet! however, it is a task that happen repetitively every week, so I want to try to have it formulated for saving time.

thank you.

#### Fluff

##### MrExcel MVP, Moderator
This works perfectly for me.. thank you so much

You're welcome & thanks for the feedback

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,029
Messages
5,856,933
Members
431,840
Latest member
simplysoph

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

### Which adblocker are you using?

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

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