Left find with multiply and less than

[julhs]

On the face of it this is really basic stuff!!
When; B3 = 2 and B4 = 0.9
And B5 is; =IF(b3*b4<1,"rr",B3*B4) result = 1.8

Not sure if it’s my imagination that when stored as TEXT and using the LeftFind function a different logic is needed?
For the life of me I just can’t get it to work, more importantly can’t figure out where I’m going wrong!

Because when numbers are stored as text eg;
B7; = 2 x xx (as text)
B8; = 0.9 x xx (as text)
And using LeftFind on B7 and B8, results are this;
B10 is; = ((LEFT(B7,FIND(" ",B7)-1)+0) = 2
B11 is; = ((LEFT(B11,FIND(" ",B11) -1)+0) = 0.9
B12 is; =((LEFT(B7,FIND(" ",B7)-1)+0)*((LEFT(B8,FIND(" ",B8)-1)+0) = 1.8
But when I then introduce an “If” & “<” argument, despite my attempts I simply can’t I get the formula to function, I get “to many arguments”, “missing parenthesis”, “formula contains an error” etc, etc
Eg;
=if((LEFT(B7,FIND(" ",B7)-1)+0)*((LEFT(B8,FIND(" ",B8)-1)+0)>1,((LEFT(B7,FIND(" ",B7)-1)+0)*((LEFT(B8,FIND(" ",B8)-1)+0)),"rr")))

00 Fert-Chemical-Nozzle calculator Currant.xlsm
	A	B	C	D
1
2			ISTEXT
3		2	FALSE
4		0.9	FALSE
5	Result	1.8	FALSE
6
7		2 x xx	TRUE
8		0.9 x xx	TRUE
9
10		2	FALSE
11		0.9	FALSE
12	Result	1.8	FALSE
13
Sheet26

Cell Formulas
Range	Formula
C10:C12,C7:C8,C3:C5	C3	=ISTEXT(B3)
B5	B5	=IF(B3*B4<1,"rr",B3*B4)
B10:B11	B10	=((LEFT(B7,FIND(" ",B7)-1)+0))
B12	B12	=((LEFT(B7,FIND(" ",B7)-1)+0)*((LEFT(B8,FIND(" ",B8)-1)+0)))

 

[julhs]

I see now why my attempt failed as it was due to the fake I had double parenthesis in front of the internal Left's

 

[julhs]

Fluff, thanks again for your help
jtakw. Realy unfair that I can only mark as solved, 1 of the 3 solutions yourself and fluff provided, but I do really appreciate your help

 

[jtakw]

You're very welcome, no problem at all, glad we can help and thanks for the feedback.