Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 22nd 09, 09:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 2
Default 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   Report Post  
Old July 22nd 09, 09:19 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 1
Default 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   Report Post  
Old July 22nd 09, 09:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default 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   Report Post  
Old July 22nd 09, 09:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 5,934
Default 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   Report Post  
Old July 23rd 09, 01:12 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 1
Default 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   Report Post  
Old July 23rd 09, 03:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Give me a Function Fareez Excel Worksheet Functions 1 June 11th 09 01:09 PM
function to give me cell reference Josh Craig Excel Worksheet Functions 5 April 2nd 09 03:45 AM
function to give the number of hours force530 Excel Worksheet Functions 3 September 22nd 06 12:03 AM
Give RELEVANT responses to questions. DO NOT give usless list pmartin Excel Worksheet Functions 2 July 6th 06 06:08 PM
How to give function by cell color to sum two value in Excel viraj Excel Worksheet Functions 4 April 28th 06 09:59 AM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017