Using text and data in formula.
 

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

Try this...


In H7 put this:

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

Howard


--
Howard Hanson
------------------------------------------------------------------------
Howard Hanson's Profile: http://www.excelforum.com/member.php...o&userid=25747
View this thread: http://www.excelforum.com/showthread...hreadid=391566

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


--
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