Home 
Search 
Today's Posts 
#1




How do I set up a function in excel to give either a < or =?
I have two columns that have two numbers and I need a function that will tell
me if the one number in one column is greater than, less than< or equal =. Thank you for your help, 
#2




How do I set up a function in excel to give either a < or =?
ivory;427015 Wrote: I have two columns that have two numbers and I need a function that will tell me if the one number in one column is greater than, less than< or equal =. Thank you for your help,There are smarter ways but assuming your numbers are in column A & B put this in C and copy down. =IF(A1B1,"A1 High",IF(B1A1,"B1 High",IF(A1<B1,"A1 Low",IF(B1<A1,"B1 Low","A1 & B1 Equal"))))  Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com)  Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=118661 
#3




How do I set up a function in excel to give either a < or =?
Simon
The A1 low & B1 low can never be called because B1 high or A1 high will evaluate as TRUE first. Mike "Simon Lloyd" wrote: ivory;427015 Wrote: I have two columns that have two numbers and I need a function that will tell me if the one number in one column is greater than, less than< or equal =. Thank you for your help,There are smarter ways but assuming your numbers are in column A & B put this in C and copy down. =IF(A1B1,"A1 High",IF(B1A1,"B1 High",IF(A1<B1,"A1 Low",IF(B1<A1,"B1 Low","A1 & B1 Equal"))))  Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com)  Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=118661 
#4




How do I set up a function in excel to give either a < or =?
Give this a try...
=CHOOSE(2+SIGN(A1B1),"Lower","Equal","Higher")  Rick (MVP  Excel) "ivory" wrote in message ... I have two columns that have two numbers and I need a function that will tell me if the one number in one column is greater than, less than< or equal =. Thank you for your help, 
#5




How do I set up a function in excel to give either a < or =?
Your right Mike, i didn't see that when cobbling that together! Mike H;427048 Wrote: Simon The A1 low & B1 low can never be called because B1 high or A1 high will evaluate as TRUE first. Mike "Simon Lloyd" wrote: ivory;427015 Wrote: I have two columns that have two numbers and I need a function that will tell me if the one number in one column is greater than, less than< or equal =. Thank you for your help,There are smarter ways but assuming your numbers are in column A & B put this in C and copy down. =IF(A1B1,"A1 High",IF(B1A1,"B1 High",IF(A1<B1,"A1 Low",IF(B1<A1,"B1 Low","A1 & B1 Equal"))))  Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage  Microsoft Office Help  Microsoft Office Discussion' (http://www.thecodecage.com))  Simon Lloyd's Profile: 'The Code Cage Forums  View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'How do I set up a function in excel to give either a < or =?  The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=118661)  Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com)  Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=118661 
#6




How do I set up a function in excel to give either a < or =?
Thank you so much, that works exactly the way I needed it.
Ivory "Rick Rothstein" wrote: Give this a try... =CHOOSE(2+SIGN(A1B1),"Lower","Equal","Higher")  Rick (MVP  Excel) "ivory" wrote in message ... I have two columns that have two numbers and I need a function that will tell me if the one number in one column is greater than, less than< or equal =. Thank you for your help, 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Give me a Function  Excel Worksheet Functions  
function to give me cell reference  Excel Worksheet Functions  
function to give the number of hours  Excel Worksheet Functions  
Give RELEVANT responses to questions. DO NOT give usless list  Excel Worksheet Functions  
How to give function by cell color to sum two value in Excel  Excel Worksheet Functions 