D
dkenebre
How do I express the following as a formula:
If any number between A1 , B1 and C1 have values that are
either one value higher or lower from each other then D1 equals Yes.
(ie 213, 049, 281, 809, 345 or 346)
but
If none of the numbers between A1 , B1 and C1 have values that
are either one value higher or lower from each other then D1 equals No.
(ie. 246, 513)
Another rule:
I am using whole number values from 0-9, 0 and 9 are the beginning and
ending parameters, therefore, they are one higher or lower to each
other
If any number between A1 , B1 and C1 have values that are
either one value higher or lower from each other then D1 equals Yes.
(ie 213, 049, 281, 809, 345 or 346)
but
If none of the numbers between A1 , B1 and C1 have values that
are either one value higher or lower from each other then D1 equals No.
(ie. 246, 513)
Another rule:
I am using whole number values from 0-9, 0 and 9 are the beginning and
ending parameters, therefore, they are one higher or lower to each
other