AnsweredAssumed Answered

Multiple If/And statements in a single calculation

Question asked by KAdams_PNFarmZ on Aug 15, 2018
Latest reply on Aug 16, 2018 by KAdams_PNFarmZ

I have a complicated "if/and" statement I need to write, which is actually probably "if/and/else".  Regardless I am having a hard time figuring out how to make it go.  A shortened version of what I need is something like this:

IF  {NH3}<5 AND {CO2} <2, then report '1'

If {NH3}<4 AND {CO2} =2, then report '1'

If 3<{NH3}<6 AND {CO2} =2, then report '2'

If {NH3}=3 AND {CO2} =3, then report '2'.  

 

and so on...

 

I'm basically trying to build a formula to autocalculate the matrix below.

      1  2  3  4  5  6  7  8 

 

5    1  2  3  4  5  6  7  8

4    1  2  3  4  5  6  7  8

3    1  1  2  3  4  5  6  7

2    1  1  1  2  3  4  5  6

1    1  1  1  1  1  2  3  4

 

Any ideas would be super helpful!  Thanks

Outcomes