Formula has stopped working

[Jenniibean]

Current formula is =A1*B1 and in C1 is the total. A1 contains a number and B1 contains the word "included" but sometimes it is a number value and not text. I formatted column B as a number so the formula was calculating the word "included" as a number but now it has stopped and it's giving me the #VALUE ! error. Tried an example below of what all needs to be calculated.

HELP!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]5[/TD]
[TD]included[/TD]
[TD]=A1*B1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2,000[/TD]
[TD]=A1*B1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

=A1*B1 will produce a value error whether column B is formatted to number or not. What is it you want it to produce as =A1*B1 obviously cant be calculated.

 

[Jenniibean]

Right now added a formula: =COUNTIF(B1,"included")*A1 and this works but it will not work if there is a number value in the B column.

 

[steve the fish]

Its not at all clear what you want. You clearly cant multiply 5 by a word. What is it supposed to produce?

 

[Joe4]

If you are trying to sew the two values together, you would use CONCATENATE or &, i.e.

=A1 & B1

If that does not do what you want, then you need to clarify, because we have no idea what you are trying to do.
If you tell us exactly what you expected results are from your examples, that would probably go a long way in helping us understand exactly what you want.

 

[Jenniibean]

I really want to multiply column A by column B which both contain numbers but sometimes the word "included" is in column B so if that's the case, i'd like the formula in column C to calculate the word "included" as the number 1.

If that makes sense or is possible.

 

[steve the fish]

Ok try:

=IFERROR(A1*B1,A1)

 

[Jenniibean]

WORKED! Thank you so much!!!!