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