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?

CHOOSE THE CLOSEST
T mobile choose number - Guide
Choose an operating system to start windows 7 - Guide
Opera gx choose download location - Guide
How does facebook messenger choose suggested - Facebook Messenger Forum
We want to make sure that it's really you using this account. choose a method below to verify that this is your account. - Yahoo Mail Forum

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

connect 2 pc's by straight cable(not cross )

How to connect two laptops using LAN cable.

choose the game application for "call of duty 4

XP startup prob: blue screen, reboot, repeat

Similar discussions

Subscribe To Our Newsletter!