Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
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 |