PureBytes Links
Trading Reference Links
|
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
|