Help with Formula OR VBA code

[Jagat Pavasia]

dear sir,

I have Main amount figure in my A6 and want to less B6 & C6, and then answer in D6.

but my B6 and C6 have some suffix in (), so please help me.
I attached photo, please find it.


I want answer in D6 which is yellow highlighted in Imag

in example my answer is 714.35

 

[Jagat Pavasia]

Hi, just another option..

Book1
	A	B	C	D
5	Main Amount	Less 1	Less 2	Answer
6	800	25.01 (D-255)	60.64 (N-23)	714.35
7	800	25.01	60.64 (N-23)	714.35
8	800	25.01 (D-255)	60.64	714.35
9	800	25.01	60.64	714.35
10	800			800
11		25.01 (D-255)	60.64	-85.65
12				0
Sheet1

Cell Formulas
Range	Formula
D6:D12	D6	=A6-LEFT(B6&"0",FIND(" ",B6&" "))-LEFT(C6&"0",FIND(" ",C6&" "))

IT IS NOT LESS AMOUNT PERFECT,
IFMY MAIN AMOUNT IS 25 AND I LESS 1.00 THEN RESULT SHOWN ME 15.
ACTUAL IS 24

 

[Jagat Pavasia]

Hi, just another option..

Book1
	A	B	C	D
5	Main Amount	Less 1	Less 2	Answer
6	800	25.01 (D-255)	60.64 (N-23)	714.35
7	800	25.01	60.64 (N-23)	714.35
8	800	25.01 (D-255)	60.64	714.35
9	800	25.01	60.64	714.35
10	800			800
11		25.01 (D-255)	60.64	-85.65
12				0
Sheet1

Cell Formulas
Range	Formula
D6:D12	D6	=A6-LEFT(B6&"0",FIND(" ",B6&" "))-LEFT(C6&"0",FIND(" ",C6&" "))

IT IS NOT WORKING

IF A HAS 25.00 AND B HAVE 1.00 THEN ANSWER SHOWN 15.00 INSTEAD OF 24.00

 

[FormR]

IT IS NOT WORKING

Sounds you do have something working though, so I'd stick with that