I need to write an embedded IF statement for a compensation report that would
do the following:
Cell A2 will be a value of 1, 2 or 3
Cell B2 will be a value of N, M or E
and
If cell A2 = 1 and cell B2 = N, enter text '0%'
If cell A2 = 1 and cell B2 = M, enter text 'a-b%'
If cell A2 = 1 and cell B2 = E, enter text 'c-d%'
If cell A2 = 2 and cell B2 = N, enter text '0%'
If cell A2 = 2 and cell B2 = M, enter text 'e-f%'
If cell A2 = 2 and cell B2 = E, enter text 'g-h%'
If cell A2 = 3 and cell B2 = N, enter text '0%'
If cell A2 = 3 and cell B2 = M, enter text 'i-j%'
If cell A2 = 3 and cell B2 = E, enter text 'k-l%'
Your help would be much appreciated!