| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Satisfying two conditions?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Satisfying two conditions?
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(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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Satisfying two conditions?
=IF(OR(MAX(A2:C2)60,LARGE(A2:C2,2)30),8,0)
Regards, Fred "Zuo" wrote in message ... 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(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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Satisfying two conditions?
=IF(MAX(A2:C2)30,8,"undefined")
"Zuo" wrote: 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(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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Satisfying two conditions?
No, the problem is that I need to satisfy either of two conditions, first
condition is, are there any of the measurements longer than 60? A MAX formula resolves that easily. The problem then becomes is the second longest side (doesn't matter which), longer than 30? First you have to determine which is the second longest and then determine if it is longer than 30. That is why in my example I use a first measurement that is the longest but less than 60 and the second longest measurement which is more than 30. "Teethless mama" wrote: =IF(MAX(A2:C2)30,8,"undefined") "Zuo" wrote: 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(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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Satisfying two conditions?
I have to give it to Fred Smith. That is what I needed, but thank you all
very much for trying to help. All your help is very much appreciated. "Fred Smith" wrote: =IF(OR(MAX(A2:C2)60,LARGE(A2:C2,2)30),8,0) Regards, Fred "Zuo" wrote in message ... 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(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 . |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Satisfying two conditions?
You're welcome, thanks for the feedback.
Fred "Zuo" wrote in message ... I have to give it to Fred Smith. That is what I needed, but thank you all very much for trying to help. All your help is very much appreciated. "Fred Smith" wrote: =IF(OR(MAX(A2:C2)60,LARGE(A2:C2,2)30),8,0) Regards, Fred "Zuo" wrote in message ... 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(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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Satisfying two variables entered via popup | Excel Discussion (Misc queries) | |||
| how to get value from a table satisfying two conditions | Excel Discussion (Misc queries) | |||
| if then statement to return text from cells satisfying condition | Excel Worksheet Functions | |||
| Satisfying 2 conditions and lookup from a 3rd column to return a v | Excel Worksheet Functions | |||
| using sumif formula: but requiring satisfying 2 if statements | Excel Worksheet Functions | |||
Linear Mode
