Logic statements

[Theresa Spezzano]

How do I get an if/or statement? this is what I put in =IF
(OR(E8="C",((C8)*(D8))/100),OR(E8="E",((C8)*(D8))),OR
(E8="M",((C8)*(D8))/1000))and it just comes up "true" what
I want is it to use the different formulas for the
different letters in column E.

Thanks for any help,
Theresa

 

[HC]

Try this,

=IF(E8="C",(C8*D8)/100,IF(E8="E",(C8*D8),IF(E8="M",(C8*D8)/1000)))