Previous Topic Next Topic

CHOOSE THE CLOSEST

Closed
andyb - Jul 22, 2010 at 11:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 22, 2010 at 05:37 PM
Hello,
Ok so column B is populated with numerous velocities (these are computed from a formula that takes a previous input) and in column C I have a bunch of AND formulas. When the velocity falls in the correct range (ex: velocity=55.345 and the formula is AND(B4>50,B4<100) It says true, and when it does not fall in the correct data range it says false. Sometimes I get a list of all false but there is always one that is really close to being true. Is there anyway to have it say true for the closest one?


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 22, 2010 at 01:47 PM
"close" is a relative term. You need to have a range where "close" is close enough to be true. Other wise as they say "a miss is as good as a mile" or (kilo meters in case you are into metrics system)
0
andyb
Jul 22, 2010 at 05:06 PM
Ok sounds good so how would I execute this?
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 22, 2010 at 05:37 PM
execute what? You need to frame the question and criteria then one can propose a solution
0

Similar discussions

Connecting Two computers, to one printer
Steve ?? -
dancedhall -

2 responses
I know my yahoo mail id and password but unable to login
Hema -
Ambucias -

1 response
connect 2 pc's by straight cable(not cross )
rohit -
kieferschild -

1 response
How to connect two laptops using LAN cable.
Sandeep -
firework -

22 responses
choose the game application for "call of duty 4
LuNiV -
xpcman -

1 response