=IF(H3<=-4000,"CAMERA",IF(H3<=-8000,"PRINTER"))

Assuming you are ahppy with false appearing if the value is not less
than 4000, the first condition will always be met if h3 <=-8000 it will
also be <=-4000 so you will never get "PRINTER" returned

Try switching you conditions

=IF(H3<=-8000,"PRINTER",IF(H3<=-4000,"CAMERA"))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=539785