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


On Sat, 19 Aug 2006 02:50:26 +0100, REK <u25476@uwe 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!