IF FUNCTION

Super Contributor

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

3 Replies

@Zan_Hanifee 

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

 

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

Screenshot (6073).pngScreenshot (6074).png

 

@Zan_Hanifee 

See the attached version.