If bank statement dr or cr add minus or plus accordingly

[DIPASGL]

Hi

I have got below data

AUD 1,768.67 CR

AUD 8,868.68 DR

This data too

Opening balance:	AUD 8,868.68 DR
Closing balance:	AUD 246,818.44 CR

I want result when dr add minus and when cr add plus .... dr or cr on Data is sometimes on 1st row or 2nd row I mean keep rows . Thanks a lot

1,768.67

-8868.68

-8868.68
246,818.44

currently I am using below formula which is giving me correct amount but have to manually add plus minus depends on dr or cr on left side.

=-MID(LEFT(B5,LEN(B5)-2),4,20)

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	AUD 1,768.67 CR	1,768.67
3	AUD 8,868.68 DR	-8,868.68
4	AUD 246,818.44 CR	246,818.44
5	AUD 123,246,818.44 DR	-123,246,818.44
Master

Cell Formulas
Range	Formula
B2:B5	B2	=MID(A2,4,LEN(A2)-6)*IF(RIGHT(A2,2)="CR",1,-1)

 

[DIPASGL]

YOU ARE GENIUS - THANKS ALOT Fluff Sorted

 

[Fluff]

You're welcome & thanks for the feedback.