Summation

[Robert Bédard]

I have to summ data that contains the sign <.

ex: summ (b1)0.08, (b2)<0.05, (B3)0.06 and (B4)0.09.

With data with < sign, the value to take is half of the
value.

Is it possible to find an equation to put in (B5)

Merci

 

[Bernie Deitrick]

Robert,

Use the array formula, entered with Ctrl-Shift-Enter:

=SUM(IF(LEFT(B1:B4,1)="<",0.5*VALUE(RIGHT(B1:B4,LEN(B1:B4)-1)),B1:B4))

HTH,
Bernie