Forum Discussion

nvconstruction2's avatar
nvconstruction2
Copper Contributor
Feb 12, 2018

Need help with formula

Hi all.
I have been trying to create a formula for the issue below but to no success. Please coukd someone give me an idea of what formula to use. If A1 = 0,12,18,21 and A2 = 1,2,3,4,SR,HR and A3 = 3, 3.5, 4 then A4 = x (Predetermined figure).
  • That could be like

    =IF(SUM(--(A1={0,12,18,21}))*SUM(--(A2={1,2,3,4,"SR","HR"}))*SUM(--(A3={3,3.5,4})),"x","")

    for A4 if you mean OR condition for values to check with A1, A2, A3

     

    • nvconstruction2's avatar
      nvconstruction2
      Copper Contributor
      Hi Sergei.

      Thank you for you're response. I have tried the formula that you sent me but it is not working. I have attached a spreadsheet of the values I'm working with.
      If i change the values in columns A B and C then i need the value in column E to correspond to what is in there at the moment.

      You're help would be greatly appreciated.

      Best regards
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        Hi,

         

        Do you mean values in column E are predefined? If, for example, you enter somewhere in 3 cells values 6, 2 and 3 the result in fourth cell shall be picked-up from E and equal to 6448?

Resources