I can't seem to firgure out how to set up the following argument in an Excell
spreadsheet!

IF cell B-6 has the value of "C" than cell J-6 = .8*H-6 and cell I-6 = .2*H-6

IF cell B-6 has the value of "P" than cell J-6 =SUM(H-6-E-6)

The part I don't understand is how to incorporate the "IF" condition.

Thanks to Anyone!