Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jan 16, 2022

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

Please help..???

 

Here is a attached file...

excel
Formulas and Functions

3 Replies

    • Excel's avatar
      Excel
      Iron Contributor
      Jan 16, 2022

      HansVogelaar 

      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.

       

Resources