I want to work out the net cost of a book from its retail cost.
If the book is published by DC the net cost is 60% of retail
If the book is published by any other publisher the net cost is 65% of
retail
So if the cells in the C column has the publishers listed and column F
is the retail cost
can I do an IF statement where if DC is true then do F1*.6, if false do
F1*.65 for column H ?
I got this far:F7 =IF(ISTEXT(C7),1,0), but that just sees if there is
text in column C.......
Any help will be greatly appreciated.
Dave
--
Dave the lost
------------------------------------------------------------------------
Dave the lost's Profile:
http://www.excelforum.com/member.php...o&userid=25746
View this thread:
http://www.excelforum.com/showthread...hreadid=391566