Forum Discussion
IF FUNCTION
Hello Everyone, i want to match the value of output as you have mentioned. it output value should be 0.3, 0.7 = 30 1 = 60 0.15, 0.55 = 15 0.45,0.85 = 45 I tried to IF FUNCTION, but not ...
I want to show :
If J3 = 0.3 or J3 = 0.7 then it should show 30
If J3 =1 then it should show 60
If J3 =0.15 or J3 = 0.55 then it should show 15
If J3 =0.45 or J3 =0.85 then it should show 45
with the help of IF with OR function ??
like i mentioned in attached file, but it will not show.
See the attached version.