In addition to RD's solution....

You don't need all of those ( ) around your logical conditions.....AND.....
if D5=20 then your formula will return FALSE.

You could shorten it to:

=IF(D5<1,0,IF(D5=1,40,IF(D5<7,80,IF(D5<12,120,IF(D 5<20,160,200)))))

OR maybe even this if D5 will be whole numbers:

=LOOKUP(D5,{0,0;1,40;2,80;7,120;12,160;20,200})

Biff

"PaulStroik" wrote
in message ...

Yes, the formula in E4 does work. Here it is. I have the cell formatted
as 'General'.

=IF((D5<1),"0",IF((D5=1),"40",IF((D5<7),"80",IF((D 5<12),"120",IF((D5<20),
"160",IF((D520), "200"))))))

Thank you both for your prompt response. I am enjoying the challenge of
figuring this out but need closure before frustration sets in.

And Greetings - New Zealand - from WI, USA


--
PaulStroik
------------------------------------------------------------------------
PaulStroik's Profile:
http://www.excelforum.com/member.php...o&userid=24640
View this thread: http://www.excelforum.com/showthread...hreadid=382343