function IF with 4 variables

[psilvaj]

Hello I have a table with four variables. By choosing each of the variables we obtain a numerical value. I have a form with each of the variables to be selected and what I meant was that it appeared the value without having to place the table on page.

 

 

 

step I (VAR 1)

VAR2    VAR3    8h 10h 12h 14h 16h 18h(VAR4)

A          0-30      4    2    1    1    2    4

A          >30      1    3    2    4    5    3

B          0-30      7    6    4    6    4    3

B            >30      4    5    3    6    3    5

C          0-30    2    2    2    2    1      8

C            >30    8    8    5    6    2      2

D          0-30    6    9    8    2    8      8

D            >30    5    5    6    8    6      8

step II (VAR1)

VAR2      VAR3    8h 10h 12h 14h 16h 18h(VAR4)

A            >30        2    3    5      8    2    6

B            >30      2    8    2      9    8    8

C            >30      8    9    2      8    5    2

D            >30      8    2    1      8    2    9

 

step I and step II is the first variable, then we have to see if it was A, B or C (second variable) and perhaps more complicated if the input value is between 0 - 30 or >30 (third variable) in stage I or greater than zero (third variable) in step II. The four variable was the hours.

 

Have any suggestions on how I do this?

 

Thanks

 

[attachment deleted by admin]