You could try

This will work if the cell is not blank.
=if(pricing!$c$2<"", pricing!b15,"")

This will work if the the cell is greater the Zero
=if(pricing!$c$20, pricing!b15,"")


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=528649