IF FUNCTION

[Excel]

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...

[#2]

@Excel 

Please explain in detail what the two lists in your worksheet mean.

[#3]

@Hans Vogelaar 

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.

[#4]

@Excel 

See the attached version.