Jan 16 2022 11:30 AM - edited Jan 16 2022 12:03 PM
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 working.
Please help..???
Here is a attached file...
Jan 16 2022 12:20 PM
Jan 16 2022 12:29 PM - edited Jan 16 2022 12:32 PM
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.