Multiply only if followed by certain character

[JAMR1988]

Good Afternoon,

I am using a Mac Pro, with Excel for Mac 2011, and I am having a problem trying to multiply a certain set of values followed by an exact letter. To be more in-depth I have varied numbers followed by a letter at certain character places and what I was wanting Excel to do was get the number Not Mattering the Character Place of the number and extract into the selected formula cell, BUT if the number was followed by a letter B than I would want excel to multiply that number by 5. If that is possible it would be greatly appreciated to receive the formula on how it would look.

Thank you for your time, and if you want an example it would be like this.

[TABLE="class: grid, width: 360"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Trap #[/TD]
[TD]Block ID[/TD]
[TD]Count Corner[/TD]
[TD]Row,Tree[/TD]
[TD]Total (B/E)[/TD]
[TD]Totals w/ Formula[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1400[/TD]
[TD]Cb2[/TD]
[TD]SW[/TD]
[TD]10,31[/TD]
[TD]1E[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1401[/TD]
[TD] [/TD]
[TD]NE[/TD]
[TD]13,18[/TD]
[TD]0[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Pg2A[/TD]
[TD]SW[/TD]
[TD]5,11[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]NE[/TD]
[TD]8,10[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Pg2B[/TD]
[TD]NE[/TD]
[TD]7,14[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SW[/TD]
[TD]6,19[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Vb2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Br2[/TD]
[TD]SW[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]NE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Br3[/TD]
[TD]SE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1403[/TD]
[TD]Mz1[/TD]
[TD]SE[/TD]
[TD]6,50[/TD]
[TD]68B[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1402[/TD]
[TD] [/TD]
[TD]NW[/TD]
[TD]6,50[/TD]
[TD]116B[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1406[/TD]
[TD]Mz2[/TD]
[TD]NW[/TD]
[TD]6,21[/TD]
[TD]4E[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1408[/TD]
[TD] [/TD]
[TD]SE[/TD]
[TD]7,25[/TD]
[TD]0[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1407[/TD]
[TD]Mz3[/TD]
[TD]NW[/TD]
[TD]8,70[/TD]
[TD]2E[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1404[/TD]
[TD] [/TD]
[TD]SW[/TD]
[TD]9,22[/TD]
[TD]3E[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1405[/TD]
[TD]Mz4[/TD]
[TD]NE[/TD]
[TD]14,13[/TD]
[TD]1E[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Mz5[/TD]
[TD]SE[/TD]
[TD]8,7[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Mz6[/TD]
[TD]NW[/TD]
[TD]10,36[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]NW[/TD]
[TD]23,26[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SE[/TD]
[TD]12,11[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1399[/TD]
[TD]Mz7[/TD]
[TD]SW[/TD]
[TD]5,9[/TD]
[TD]12E[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]8/2/14[/TD]
[TD]1408[/TD]
[TD]Pk2[/TD]
[TD]NW[/TD]
[TD]9,28[/TD]
[TD]25E[/TD]
[TD]FORMULA[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcílio_Lobão]

JAMR1988, Good evening.

"...am using a Mac Pro, with Excel for Mac 2011..."
I'm not sure if it woks on MAC.

Try to use:

=IF(ISTEXT(A1),IF(RIGHT(A1,1)="B",VALUE(LEFT(A1,LEN(A1)-1))*5,VALUE(LEFT(A1,LEN(A1)-1))),
A1)

Is it what you want?
I hope it helps.

 

[JAMR1988]

Amazing, you my friend are on a streak!!

It worked perfectly, apart from me converting a couple formula headings but the ones you got weren't that far from theirs, you know how Mac loves to set themselves apart from everything. But anyways very appreciative of that thank you very much!!