Help!! Newbie needs help with a formula

[JWERBA]

Does someone know how to achieve the following:

I2 = 35%
J2 = 60%

Here is what I need to appear in K2: Take the greater value of I2 and J2 unless I2 or J2 is over 50%, then take the other value. So, in this case it would return 35%.

Thanks,

 

[Michael M]

Hi and welcome to the Board
Try, which also will give a blank, if both are over 50%

Excel 2007
	I	J	K
2	45%	35%	45%
Sheet1

Cell Formulas
Range	Formula
K2	=IF(AND(I2>50%,J2>50%),"",IF(I2>50%,J2,IF(J2>50%,I2,MAX(I2:J2))))

 

[AlphaFrog]

Try this...

=IF(MAX(I2:J2)>50%,MIN(I2:J2),MAX(I2:J2))

 

[Michael M]

Doh....much better...ray:

 

[kevinb11]

Excel Workbook
	I	J	K
2	35%	60%	35%
Sheet1

 

[JWERBA]

Thanks All, it works!!

Hi and welcome to the Board
Try, which also will give a blank, if both are over 50%

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>I</TH><TH>J</TH><TH>K</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right">45%</TD><TD style="TEXT-ALIGN: right">35%</TD><TD style="TEXT-ALIGN: right">45%</TD></TR></TBODY></TABLE>

Sheet1​

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>K2</TH><TD style="TEXT-ALIGN: left">=IF(AND(I2>50%,J2>50%),"",IF(I2>50%,J2,IF(J2>50%,I2,MAX(I2:J2))))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

 

[JWERBA]

Thank you!!

Excel Workbook
	I	J	K
2	35%	60%	35%
Sheet1

 

[JWERBA]

Thank you all!!

 

[kevinb11]

Thanks for the feedback.