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")))
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))) |
Last edited: