If the only two options for B6 are "C" and "P", you can use:
J6 formula =IF(B6="C",0.8*H6,SUM(H6,E6))
I6 formula =IF(B6="C",0.2*H6)

If you want the value to be something else (0 in this case) if B6 is not "C"
or "P", use this:

J6 formula =IF(B6="C",0.8*H6,IF(B6="P",SUM(H6,E6),0))




"REK" wrote:

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!