Hi Adithya,
Whe you have complex IF ELSE Formulae...then BREAK them up into small peices so that you know where hte issue is..
CKF1 =(Condition==1) * NOERR (NODIV ( ( A/B ) ) ) * 30
CKF2=(Condition 2==1) * NOERR ( NODIV( ( ( A- B-B1)/B2 * 30 + 60) ) )
CKF3=(Condition3==1) * NOERR (NODIV( (A/B)))* 30
CKF4=(Condition4==1) * 0
Then add them up
CKF5=CKF1+CKF2+CKF3+CKF4.
For your own testing display all the CKFs.all 5 and during final Transport ... hide the CKF1/CKF2/CKF3/CKF4 and display CKF5
rgds
SVU
Hi
Please once try with the below one.
(Condition==1) * (NOERR (NODIV ( ( A/B ) ) ) * 30 ) + (Condition 2==1) * (NOERR ( NODIV( ( ( A- B-B1)/B2 * 30 + 60)) ) ) + (Condition3==1) *( NOERR (NODIV( (A/B)))* 30 + 60 )
(Condition4==1) * 0
Just keep the condition value in the bracket and try once.
Hi,
Condition 4: B=-B i.e. if B is negative Condition 4 must be outermost in the nested if. If its priority is highest. I understood is correct then the solution given by @SUV 123 can be modified as below;
CKF1 = A>B * NOERR (NODIV ( ( A/B ) ) ) * 30
CKF2 = A<B * NOERR ( NODIV( ( ( A- B-B1)/B2 * 30 + 60) ) )
CKF3 = A=B * NOERR (NODIV( (A/B)))* 30
CKF4 - B<0 * 0 + B>0 * CKF1+CKF2+CKF3
Hope this gives you desired solution.
Regards,
Sucheta
Issue resolved.It was the bracked issue.All your posts helped 😊 The NOERR,NODIV brackets will close at *30 only.That was the issue.
Add comment