excel formula.

  • Thread starter Thread starter George A. Yorks
  • Start date Start date
G

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
 
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
 
Back
Top