Sum and Minus in column

[hailstorm]

Hello there

I'd like to know if i can use a formula to sum and minus equations in a particular log that i have. I can use the very basic formula " =c2-e2 " , but since the log is very long i don't any do that manually for every sum and minus.

there is a column with sum and minus, i'd like to know if i can use a formula selecting that column to do the equation.

 

[Peter_SSs]

Try

=C2+IF(D2="-",-E2,+E2)

 

[Peter_SSs]

.. another option

=C2+E2*SIGN(D2&1)

 

[hailstorm]

Try

=C2+IF(D2="-",-E2,+E2)

It worked, thank you!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.