Or Statement?

[Tony]

Hello,

Frank. you helped me earlier on a formula and maybe you
can help me on this one too. I am thinking that I need
to have something equivalent to an "OR" statement but I
dont know of one.

I have a formula =
=IF(AND(AA16=5,AB16=10),AH16*19/55,IF(AND
(AA16=5,F16=20),AH16*74/210, IF(AND
(AA16=4,AB16=8),AH16*15/36,IF(AND
(AA16=4,AB16=16),AH16*58/136))))

This formula only works if the cells AA16=5 and AB16=10.
If those two cells are any of the other values in the
formula then it returns "FALSE". I want it to calculate
and dont want it to return "FALSE". I am thiking there
has to be something equivalent to "OR" in this formula to
make it work if AA16 and AB16 are any other values
besides 5 and 10 (they could be 5 & 20 or 4 & 8 or 4 &
16).

Thank you

 

[Frank Kabel]

Hi Tony
you just have to add the last FALSE statement. What should the formula
return in these cases? a zero?.

try
=IF(AND(AA16=5,AB16=10),AH16*19/55,IF(AND
(AA16=5,F16=20),AH16*74/210, IF(AND
(AA16=4,AB16=8),AH16*15/36,IF(AND
(AA16=4,AB16=16),AH16*58/136,0))))

 

[Tony]

Hi Frank,

The formula should never return a zero. Those cells will
only be the values in the formula (5,10 or 5,20 or 4,8).
I tried the formula but it returned a 0. Maybe this type
of formula is not correct for what i want to do. Have
any other ideas?

thanks,
Tony

 

[Frank Kabel]

Hi Tony
you may explain what result you want if your existing aND conditions
are not met. What do you want to calculate in these cases?

 

[Tony]

Frank,

My conditions will always be met. There will never be a
case where the and conditions will be false. The cells
will always equal one of those conditions.

Regards,
Tony

 

[JohnI in Brisbane]

Tony,

Some thoughts on your question.

=IF(AND(AA16=5,AB16=10),AH16*19/55,
IF(AND(AA16=5,F16=20),AH16*74/210, <- Have you
noticed that this has "F16=20" not "AB16=20"?!
IF(AND(AA16=4,AB16=8),AH16*15/36,
IF(AND(AA16=4,AB16=16),AH16*58/136,"Error")))) <- There was an open
FALSE result on this line. I have placed "Error", where the result should
go.


Perhaps your results in AA16 or AB16 are not exactly integers, i.e. you are
getting rounding problems.
Another alternative is that you have a text format for AA16 and/or AB16.


regards,

JohnI

 

[Tony]

Thank you, John. It was a mistake. I had changed the
worsheet around and made some changes to it and changed
the formula around and I made it work.

Tony

-----Original Message-----
Tony,

Some thoughts on your question.

=IF(AND(AA16=5,AB16=10),AH16*19/55,
IF(AND

(AA16=5,F16=20),AH16*74/210, <-
Have you