Thanks, that helps. So far so good, but I'm having a problem. Here
is the first part of my formula, which works fine.

=IF($B$167,"ERROR",IF($D$167,"ERROR",IF($D$16="" ,$E$16*-50,IF($D$16<$B$16,"ERROR",IF(OR($C$16={"c","d"}),I F($B$16=7,$D$16*20+
300+1000,IF($B$16=6,$D$16*20+300+500,IF($B$16=5, $D$16*20+300,IF($B$16<5,$D$16*20+50)))))))))

To finish it, I'm trying to add the following to this formula; but it
always returns false. Both formulas work as a stand alone, but not
combined (at least the way I'm doing it.)
Obviously I'm doing something wrong.


=IF(OR($C$16={"h","s"}),IF($B$16=7,$D$16*30+300+10 00,IF($B$16=6,$D$16*30+300+500,IF($B$16=4,$D$16* 30+300,
IF($B$16<4,$D$16*30+50

What is the proper way to combine these two sections?

Thanks again.

On Sat, 7 Mar 2009 07:16:01 -0800, francis
wrote:

Hi Jim

these {"c","d"} is an array and is a shorter way to the first formula
on the specified criteria in your example
the formula will be evaluating if cell C16 is "c" or "d" and if they are
b16*d16 will apply otherwise it will return "what goes here"