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!

## Bookmarks