Hello
Is it possible to insert EXCEL functions into the Conditional property of SmartProperties? If so, is it the same way to write them as sr EXCEL?
Or is it just possible to do SI(testlogical|yes|no)?
Thanks in advance!
For the conditionals, the form is good as in the example (logical test, on the other hand, you can accumulate several in a row.
It's true that it's not very practical and that the excel form is much easier.
Here's an example of a cumulative conditional test:
IFF($Ep-Ray=1-1.3||IFF($Ep-Ray=1.2-1.3||IFF($Ep-Ray=1.5-2||IFF($Ep-Ray=2-2.6||IFF($Ep-Ray=2.5-2.6||IFF($Ep-Ray=2.5-4||IFF($Ep-Ray=3-4||IFF($Ep-Ray=4-4||IFF($Ep-Ray=4-5||IFF($Ep-Ray=5-5||IFF($Ep-Ray=5-8||IFF($Ep-Ray=6-8||IFF($Ep-Ray=8-10||IFF($Ep-Ray=10-10||IFF($Ep-Ray=1.5-2||IFF($Ep-Ray=12-10||IFF($Ep-Ray=15-10||IFF($Ep-Ray=-||Error Ve)
In the end, something quite complicated to understand!
3 Likes
Afterwards if necessary I can give you a hand if you tell me what you want to achieve as a condition.
If it is feasible.
Otherwise, as Coluche said, tell me what you need, I'll tell you how to do without it.
3 Likes
Not very practical indeed
In fact I am trying to create a range of values in the logical test part, for example:
If Property1 is between 00 and 09, then yes, otherwise no.
I've tried with OU/AND functions and with > and <, but it doesn't work (I may have used the wrong syntax)
Do you have an idea?
1- you have to be sure that the value retrieve is numeric because 09 is more text
2-integer or the result can be with decimal of the order of 2.24555.
Otherwise, the principle for accumulating iffs is as follows.
IFF($Propri summer1=0|yes|no) for a line
If you want to cumulate, you take your 1st line, copy paste and instead of the no, you paste your formula and you modify the value.
IFF($Propri summer1=0|yes|IFF($Propri summer1=2|yes|no))
The easiest way is to do a clean test
you create your piece with a given value of property 1 you create your formula and you test it me I created my formula with 1 condition, then 2 then 3... by testing as you go to make sure you don't make a mistake.
For your formula it must be something like this to test.
IFF($Propri summer1>9|no|IFF($Propri summer1>=0|yes|no))
Basically, if property1 >9, no, otherwise we test if property1>=0.
Not tested but it should work
Thank you!
I had also thought of this trick but hey I have 9 families of parts of which the first, for example, must be found with 00,01,02,03,04,05,06,07,08,09... the second: 10,11,12,13... etc...
It may take a very long time
Thank you in any case for your answers!