quick formula question....

  • Thread starter Thread starter Dan B
  • Start date Start date
D

Dan B

I need to test the value of three cells individually in one formula. If any
one of them exceed a certain amount, I need a calulation made. Here is my
formula that did not work.....I got the #value! error.

=if((A1,A2,A3>500000),B4*B5,"")

If I look at one cell it works. I'm sure the problem is in the A1,A2,A3
part. I also tried A1:A3, which did not work. What is the correct syntax
to use to look at three cell values individually?

Thanks,
Dan
 
Dan B said:
I need to test the value of three cells individually in one formula. If any
one of them exceed a certain amount, I need a calulation made. Here is my
formula that did not work.....I got the #value! error.

=if((A1,A2,A3>500000),B4*B5,"")

If I look at one cell it works. I'm sure the problem is in the A1,A2,A3
part. I also tried A1:A3, which did not work. What is the correct syntax
to use to look at three cell values individually?

Thanks,
Dan
Click to expand...

The straightforward answer is:
=IF(OR(A1>500000,A2>500000,A3>500000),B4*B5,"")
In other words, perform three individual comparisons and OR the results to
give you one result. However, in this particular situation there is an
alternative. You can find the largest of A1, A2 and A3, and perform just one
comparison (as you are then not interested in the results of the other two).
So:
=IF(MAX(A1,A2,A3)>500000,B4*B5,"")
 
Back
Top