[RT] excell question

[Proffittak@xxxxxxx]

hi


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)

thanks in advance
Ben