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

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

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

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