KL,
Thanks again. I'll remember this one.
Jeff


"KL" wrote in message
...
Hi Jeff,

on the last part it is ... IF(Data!S9,Data!R8,"Apples")). My question is
why the comma between Data!S9 and Data!R8? Does the comma mean the same
as equals?

Not exactly. The structure is:

IF(Condition,OutcomeIfTrue,OutcomeIfFalse)

Basically the formula

IF(Data!S9,Data!R8,"Apples")

is equal to

IF(Data!S9=TRUE,Data!R8,"Apples")

but the former is shorter.

Actually the formula:

IF(Data!S9,...)

can be used to test two things 1) if Data!S9 is equal to TRUE or 2) if
Data!S9 is not equal to 0


Regards,
KL