Satisfying two conditions?
in [Functions]
|
Prev: Format Data Labels
Next: Drill down via page fields
From: Zuo on 24 Apr 2010 10:28 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
From: JLatham on 24 Apr 2010 10:34 For entries on row 2: =IF(OR(A2>60,B2>30),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
From: Zuo on 24 Apr 2010 10:40 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(A2>60,B2>30),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
From: Fred Smith on 24 Apr 2010 10:53 =IF(OR(MAX(A2:C2)>60,LARGE(A2:C2,2)>30),8,0) Regards, Fred "Zuo" <Zuo(a)discussions.microsoft.com> wrote in message news:D59AB420-2469-4141-82F1-B1F1E6F89FA5(a)microsoft.com... > 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(A2>60,B2>30),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
From: T. Valko on 24 Apr 2010 10:54
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" <Zuo(a)discussions.microsoft.com> wrote in message news:28E580EA-7E3E-4033-BFEF-52E1F2668F27(a)microsoft.com... >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 |