| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which function can get the desired result?
Is there a function for this:
example: cell B1 = 115 cell B2 = 120 cell B3 = 200 B1 thru B3 are variables that will change based on user input. I want cell B4 to equal "CC" if B1 is closer to B2, but if B1 is closer to B3 than B2, B4 will equal "C" Any function(s) that can get this result? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
which function can get the desired result?
Hi try
=IF(B3-B1B2-B1,"C","CC") -- Regards, Sebation.G "ADK" ... Is there a function for this: example: cell B1 = 115 cell B2 = 120 cell B3 = 200 B1 thru B3 are variables that will change based on user input. I want cell B4 to equal "CC" if B1 is closer to B2, but if B1 is closer to B3 than B2, B4 will equal "C" Any function(s) that can get this result? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
which function can get the desired result?
=IF(ABS(B2-B1)<ABS(B3-B1),"CC","C")
"ADK" wrote: Is there a function for this: example: cell B1 = 115 cell B2 = 120 cell B3 = 200 B1 thru B3 are variables that will change based on user input. I want cell B4 to equal "CC" if B1 is closer to B2, but if B1 is closer to B3 than B2, B4 will equal "C" Any function(s) that can get this result? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
which function can get the desired result?
=IF(ABS(B1-B2)<ABS(B1-B3),"CC","C")
You haven't said what you want as an output if B1 is equidistant from B2 and B3. -- David Biddulph "ADK" wrote in message ... Is there a function for this: example: cell B1 = 115 cell B2 = 120 cell B3 = 200 B1 thru B3 are variables that will change based on user input. I want cell B4 to equal "CC" if B1 is closer to B2, but if B1 is closer to B3 than B2, B4 will equal "C" Any function(s) that can get this result? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IRR desired return | Excel Worksheet Functions | |||
| Can not get function result | Excel Discussion (Misc queries) | |||
| HOW TO GET A DESIRED 'SUMIF' RESULT FROM A FILTERED DATA | Excel Worksheet Functions | |||
| Simplicity is Desired | Excel Worksheet Functions | |||
| function based on result of same function | Excel Discussion (Misc queries) | |||
Linear Mode
