# Checking a Cell for an *

#### Takron

##### New Member
I'm trying to come up with a formula to check a cell for an * to determine how to figure for a budget sheet.

I am trying to split bills in half between two parties but some of the bills are only for one of the parties so I want to put an * on those bills to skip the divide action so i don't have to write a function for every time we need to skip the divide by 2 action. I have included a pic of the sheet I'm making for reference. I am including a rough wording to help explain what I am trying to do but i don't know how to format it for excel.

If I6 contains "*" then 0+0 else J6/2

Imgur

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
maybe
=IF(I6="*",0+0,J6/2)

Its just doing the division. Its not checking for the *

It works for me

Excel Workbook
IJKLMN
52311.5
6*6565
Sheet3

Maybe

Code:
``=IF(I6=Char(42),0+0,J6/2)``

It works for me

Sheet3

 * I J K L M N 5 * 23 * * * 11.5 6 * 65 * * * 65

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

 Cell Formula N5 =IF(I5="*",J5,J5/2) N6 =IF(I6="*",J6,J6/2)

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

It does but I need that * to be detected in a cell with other words.

It does but I need that * to be detected in a cell with other words.

That helps

Excel Workbook
BCDE
14words115.5
15text178.5
16apple136.5
17more * words1414
18more words*1515
Sheet12

Awesome. Thank you so much. works like a charm.

Pleased to help. thanks for ackn.

Replies
12
Views
560
Replies
2
Views
341
Replies
8
Views
770
Replies
7
Views
287
Replies
9
Views
1K

1,203,606
Messages
6,056,281
Members
444,854
Latest member
goethe168

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