Using text and data in formula.

[Dave the lost]

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

 

[Howard Hanson]

Try this...


In H7 put this:

=IF(C7="DC",0.6*F7,0.65*F7)

Howard

 

[Dave the lost]

Thank you Howard, it works a treat !!
You wont believe how long my friend Jeff and I have been puzzling over
this.
Thank you, thank you, thank you.

Dave