excel formula.

[George A. Yorks]

=IF(Sheet1!B4=Sheet1!B1,2,If(Sheet1!B4>Sheet1!B1,1,If
(Sheet1!B4<Sheet1!B1,4)

In the above formula how would I insert an incremental
amount.

ie: If(Sheet1!B4>Sheet1!B1,1, the increase to be by
two and the result remain one.

ie: (Sheet1!B4<Sheet1!B1,4) the decrease be by 1
with the result remaining 4

 

[boris]

I am sure that what you want to do is possible, but you
have to be a little more descriptive to make us
understand. Thanks. Ideally, put up some cell names, put
values, then say what you want done.

Boris