Good morning Chris McDannold

This formula will do what you want by checking the cell A1 (you haven't
specified). You didn't mention what is to return if the value of the
cell being checked is less than 20. In the example below a zero is
returned.

=IF(A1=40,3,IF(A1=30,2,IF(A1=20,1,0)))

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=395528