Jim, thanks for the reply

I was wondering was if I implement

=IF(D7="Product 1",J7,M7/Q7*1000)

As I am looking to work against 2 products

would it look like

=IF(D7="Product 1",J7,M7/Q7*1000)(D7="Product 2",=H7) so that the fixed
price items are transferred across

Hope I am making sense :)


--
chockee
------------------------------------------------------------------------
chockee's Profile: http://www.excelforum.com/member.php...o&userid=31886
View this thread: http://www.excelforum.com/showthread...hreadid=516133