nested IF function

[Lou]

Hi
I'm trying to create an IF function where I want to achieve a result if in D3
0 to 18 = A
19 to 27 = B
28 to 36 = C
36 and over = D
Obviously the following function is not correct - can anyone help please.

IF(D3>0,D3<=18,A,IF(AND(D3>18,D3<=27,B,IF(AND(D3>0,D3<=18,C,IF(AND(D3>36,D,)))))))

[zbor]

Here, try this:

=LOOKUP(D3,{0,19,28,36},{"A","B","C","D"})

(wich will result you with error if you enter negative number)

or this

=LOOKUP(MAX(0,D3),{0,19,28,36},{"A","B","C","D"})

(wich will return A even for negative numbers)

[DonkeyOte]

From an embedded IF perspective....

An IF will exit upon first TRUE result so you need not repeatedly use prior tests.

Also we're assuming the value being tested does not reside in the cell you're placing the formula - your post is unclear.

=IF(D3<=18,"A",IF(D3<=27,"B",IF(D3<=36,"C","D")))

You might want to validate D3 is a number as well...