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, |
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 |
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 |
How do I set up a function in excel to give either a < or =?
Give this a try...
=CHOOSE(2+SIGN(A1-B1),"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, |
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 |
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(A1-B1),"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, |
All times are GMT +1. The time now is 11:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com