Should C13 be

=IF(SUM($B$12:C12)0,ROUND(C12*C7,0),0)

which you copy across.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"derekblain" wrote
in message ...

Good Morning Bob -

I tried doing that last night but saw that users can only bitmaps and
docs - there was no option for posting xls files.

I've zipped it up and have now attached it this way. If this is
incorrect and there is another way to post, let me know.

Thanks,
Derek


+-------------------------------------------------------------------+
|Filename: Incentive Worksheet.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5156 |
+-------------------------------------------------------------------+

--
derekblain
------------------------------------------------------------------------
derekblain's Profile:
http://www.excelforum.com/member.php...o&userid=37171
View this thread: http://www.excelforum.com/showthread...hreadid=568877