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)
andyb
Jul 22, 2010 at 05:06 PM
Ok sounds good so how would I execute this?
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

Similar discussions

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

2 responses
XP startup prob: blue screen, reboot, repeat
hepdoll -
dilk -

52 responses
Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
reboot Toshiba MK6475GSX (S1)
bchow -
xpcman -

1 response
choose the game application for "call of duty 4
LuNiV -
xpcman -

1 response