Creating "IF" arguments

  • Thread starter Thread starter REK
  • Start date Start date
R

REK

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!
 
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))
 
Dan has given the answer.

A point when writing/refereing to cells it's easier to just write J6, H6,
E6 etc rather than J-6 H-6 E-6

Certainly makes H-6-E-6 less confusing to when it appears as H6-E6

:)

Steve
 
Back
Top