Hi

E1=IF(D1="",C1,D1)*(0.8+0.05*(IF(D1="",C1,D1)<1000 ))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"stillgreen" wrote
in message ...

old price column C1 - C422
new price column D1 - D422 (not a new price for every product
though)
our cost column E1

our cost is X times .80 if the price is 1000
and X times .85 if the price is < 1000


--
stillgreen
------------------------------------------------------------------------
stillgreen's Profile:
http://www.excelforum.com/member.php...o&userid=31718
View this thread: http://www.excelforum.com/showthread...hreadid=514219