greater/lesser than

[gma]

if a1 is a base number of 100 and b1 is 95 how do i get c1 to be greater or
lesser than b1.

 

[Mike H]

You need to provide more details, what are the rules for the value in C1

Mike

 

[Shane Devenshire]

Hi,

If A1=100 and B1=95

in C1 enter any formula that
=B1-1 will make it less
or
=B1+1 will make it more

But then any number, other than 0, added or subtracted from B1 will make it
less or more. And what does A1 have to do with it at all?

 

[Fred Smith]

Gma,

What we have here is a failure to communicate. You've tried more than once
to explain your problem, but have not succeeded. In this post, for example,
c1 will always be "greater or lesser than b1". So what's the problem?

I suggest you try giving examples. With a1 fixed at 100, if b1 is 95, what
do you want in c1? If b1 is 90, what's c1? if b1 is 105, what should c1 be?
Maybe from the examples, we can figure out the formula you want.

Regards,
Fred.

 

[gma]

i understand i'm not communicating very well or at all, i'm trying.let me try
this.
A1 is 95 and if it changes to 96 then I want B1 to increase what ever the
number is in B1. If A1 number changes to 94 then i want B1 number to
decrease. Would it be a formula like =If(B1<than A1 then B1-1," if B1>than A1
than B1+1) i dont know. it would be nice if i could just send you a copy of
the spreadsheed so you can see what i'm trying to do.

 

[joeu2004]

A1 is 95 and if it changes to 96 then I want B1 to
increase what ever the number is in B1.

English language correction.... I think you mean: if A1 is 95 and B1
is 96, you want C1 to be B1 plus the difference between A1 and B1.
Right? At least, that requirement seems to be consistent with the
pseudocode you write below.

(You do not want to detect a change in A1 ("if __it__ changes to
96"). And you do not want to change the value in B1 based on its
value before the change ("want __B1__ to increase whatever the number
is in __B1__").)

If A1 number changes to 94 then i want B1 number to
decrease. Would it be a formula like =If(B1<than A1 then B1-1,"
if B1>than A1 than B1+1) i dont know.

Well, I think that would be simply:

C1: =B1+(B1-A1)

But I am not sure you are properly communicating your true
requirements. The requirements specified here sounds very difference
from the requirements that you specify in the "gain-loss" thread (but
then again, the latter requirements were never clearly stated either,
IMHO). And I suspect these two threads are related. ;-)

it would be nice if i could just send you a copy of
the spreadsheed so you can see what i'm trying to do.

IMHO, that would not help. You simply need to post the existing
formulas in relevant cells, the current outcome that is presumably
wrong, and the desired outcome for at least two complementary
examples, and perhaps more than two.

For example, in this thread, you say that you might want C1 to be B1
plus or minus when B1 is one more or less than A1. But I wonder
(again, partially influenced by my dubious interpretation of the "gain-
loss" thread) if you really want C1 to be B1 plus the percentage
change from A1 to B1, not the cardinal number change.

In other words, what if A1 is 100 and B1 is 90. Do you want C1 to be
80 (B1-10)? Or do you want C1 to be 81 (10% less than B1, because B1
is 10% less than A1)?

And if neither of those is right, what am I misunderstanding?


----- original posting -----