Or Function
It took a while but I think I got it. It has to do with the number of
parenthesis between the two sections:
=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"}),
IF($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)))),
IF(OR($C$16={"h","s"}),IF($B$16=7,$D$16*30+300+100 0,IF($B$16=6,$D$16*30+300+500,IF($B$16=4,$D$16*3 0+300,
IF($B$16<4,$D$16*30+50))))))))))
On Sat, 07 Mar 2009 09:46:07 -0800, JimS wrote:
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+1 000,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"
|