View Single Post
  #8  
Old April 24th, 2010, 04:44 PM posted to microsoft.public.excel.worksheet.functions
Zuo
external usenet poster
 
Posts: 24
Default Satisfying two conditions?

I have to give it to Fred Smith. That is what I needed, but thank you all
very much for trying to help. All your help is very much appreciated.

"Fred Smith" wrote:

=IF(OR(MAX(A2:C2)60,LARGE(A2:C2,2)30),8,0)

Regards,
Fred

"Zuo" wrote in message
news
No, it must be if any of the numbers are greater than 60 or if the second
longest is greater than 30. You must take into account all numbers all
the
time.

"JLatham" wrote:

For entries on row 2:
=IF(OR(A260,B230),8,1)
Ok, you may want a different number than 1 for the other cost, but I'm
trying to attract customers for you.


"Zuo" wrote:

I need to satisfy the following condition: If the longest side of a
box is
greater than 60 or its second longest side is greater than 30, then
charge
$8. I have the Length, Width and Height measurements of each package
in
columns A,B, C.

Example
ABC
59,35,15

Thanks in advance for the help.
Regards,
ZUO


.