Satisfying two conditions?
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
|