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
|