close
I need to find out a formula that increases one number when the other
decreases, but does not decrease the number when the other increases.
example
cell A1=30 B1=40
NEXT
cell A1=31 B1=39
but not when there is an increase
cell A1=31 B1=42
I'm thinking you'll need to have a helper column to do this or else you'll
have circular references.
quot;Joseph Weberquot; lt;Joseph gt; wrote in message
...
gt;I need to find out a formula that increases one number when the other
gt; decreases, but does not decrease the number when the other increases.
gt; example
gt; cell A1=30 B1=40
gt; NEXT
gt; cell A1=31 B1=39
gt; but not when there is an increase
gt; cell A1=31 B1=42
gt;
gt;
全站熱搜
留言列表
