A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Satisfying two conditions?



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2010, 03:28 PM posted to microsoft.public.excel.worksheet.functions
Zuo
external usenet poster
 
Posts: 24
Default 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  
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

  #3  
Old April 24th, 2010, 03:40 PM posted to microsoft.public.excel.worksheet.functions
Zuo
external usenet poster
 
Posts: 24
Default 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  
Old April 24th, 2010, 03:53 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default Satisfying two conditions?

=IF(OR(MAX(A2:C2)60,LARGE(A2:C2,2)30),8,0)

Regards,
Fred

"Zuo" wrote in message
news
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  
Old April 24th, 2010, 03:54 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default 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  
Old April 24th, 2010, 04:19 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
 
Posts: 3,722
Default 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  
Old April 24th, 2010, 04:38 PM posted to microsoft.public.excel.worksheet.functions
Zuo
external usenet poster
 
Posts: 24
Default 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  
Old April 24th, 2010, 04:44 PM posted to microsoft.public.excel.worksheet.functions
Zuo
external usenet poster
 
Posts: 24
Default 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
news
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  
Old April 26th, 2010, 06:05 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default 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
news
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


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.