[RT] Re: excell question

[Bob Fulks <bfulks@xxxxxxxxxxxx>]

At 9:35 AM -0400 6/3/00, Proffittak@xxxxxxx wrote:
>for the  experts out there
>
>how do i tell excel   to do the following
>
>if the  number is  1 or larger  add  to  the total of last 4
>if the number is  UNDER 1  then add : 1  minus  the  fraction( and with a
>MINUS)
>
>example    2.1 +1.9  +. 37+ . 69 the
>answer will be   3.06
>
>because  .37 is =to (-.63)  and    .69  =(-.31)

I am assuming you want this to follow down a column.

Assume the numbers are in column E beginning in row 1 through row 4, and assume you want the result in column F just to the right of the last number.

The content of cell F2 would be

  =IF(E2>1,F1+E2,F1-(1-E2))

and copy down the F column.

This says "if the value in cell E2 is > 1 then the value of cell F2 is equal to F1 + E2 else the value of cell F2 is equal to the value of cell F1 - (1 - the value of cell E2)

Bob Fulks