| Home |
| Search |
| Today's Posts |
|
#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, |
| 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 | |||
Threaded Mode
