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)))

 

[Fluff]

As you are multiplying the numbers, you don't need to add 0, you can just use

=IF(LEFT(B7,FIND(" ",B7)-1)*LEFT(B8,FIND(" ",B8)-1)>1,LEFT(B7,FIND(" ",B7)-1)*LEFT(B8,FIND(" ",B8)-1),"rr")

 

[jtakw]

Hi,

You can also skip the -1

 

[julhs]

Lighting fast response Fluff, thank you.
Perfect; you solved in minutes something I’d been puzzling over for hours

 

[Fluff]

Glad we could help & thanks for the feedback

 

[julhs]

Sorry I’m now utterly confused.
Can both be right?

To take out the 0 and leave the -1
Or leave the 0 and take out the -1

 

[Fluff]

You can take them out, or leave them as you wish. You don't need either the +0 or -1 as you are multiplying the results.

 

[jtakw]

You can do just this:

Book3.xlsx
	B
7	2 x xx
8	0.9 x xx
9
10
11
12	1.8
Sheet949

Cell Formulas
Range	Formula
B12	B12	=IF(LEFT(B7,FIND(" ",B7))*LEFT(B8,FIND(" ",B8))>1,LEFT(B7,FIND(" ",B7))*LEFT(B8,FIND(" ",B8)),"rr")

 

[julhs]

Looking at both your examples, it's safe to say that my attempt had the parenthesis all wrong, with or without the -1 or +0

 

[jtakw]

If you were to leave the +0 and -1 in the formula, it should look like this:

=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")