AnsweredAssumed Answered

TROUBLE IN IFF/AND STATEMENT

Question asked by rajesdeo Employee on Oct 2, 2016
Latest reply on Sep 19, 2017 by berndh

Can Someone help me in converting below logical statements to IR.

 

1st statement

=IF(AND(A<=101.5,A>=98.5),(K*S),IF(A<98.5,(98.5-A)+K*S,IF(A>101.5,(A-101.5)+K*S)))

 

2nd Statement

IF X=30 Then A=2 ,IF X=10 Then A=2.4 Otherwise Display "Not Applicable"

 

 

Thanks & Regards

Rajesh Deo

Outcomes