Checking a Cell for an *

[Takron]

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

 

[konew1]

maybe
=IF(I6="*",0+0,J6/2)

 

[Takron]

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

 

[konew1]

It works for me

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

 

[Michael M]

Maybe

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

 

[Takron]

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>

Spreadsheet Formulas

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.

 

[konew1]

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

That helps

Excel Workbook
	B	C	D	E
14	words		11	5.5
15	text		17	8.5
16	apple		13	6.5
17	more * words		14	14
18	more words*		15	15
Sheet12

 

[Takron]

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

 

[konew1]

Pleased to help. thanks for ackn.