View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Satisfying two conditions?

You don't say what result you want if either condition is not met.

Try one of these...

This one will return either 8 or 0:

=(MAX(A2:C2)=30)*8

This one will return either 8 or blank:

=IF(MAX(A2:C2)=30,8,"")

--
Biff
Microsoft Excel MVP


"Zuo" wrote in message
...
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