View Single Post
  #2  
Old April 24th, 2010, 03:34 PM posted to microsoft.public.excel.worksheet.functions
JLatham
external usenet poster
 
Posts: 1,896
Default 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