oldchippy Wrote:
Hi jrabs12,

Try this formula

=IF((C2-D9)*F9<=0,0,C2-D9)*F9

This says at if your result is less than or equal to zero, display
zero, otherwise result is positive

oldchippy ;)

hate to say it but that won't work you've missed off various
brackets...


=IF((C2-D9)*F9<=0,0,*(*C2-D9)*F9*)*


my formula doesn't need the "=<" as anything less will put a zero
otherwise it does the original formula, you added an extra unecessary
parameter.


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=569032