VBA Doing Addtion for one column to the other

[BenjaminLWX]

0.002456706 0.002802535 0.003163419 0.003538764 0.00392804 0.004330764 0.004746497 0.005174833 0.0056154 0.006067848 <colgroup><col></colgroup><tbody> </tbody>

-7.77544E-05 -0.000155509 -0.000233263 -0.000311018 -0.000388772 -0.000466527 -0.000544281 -0.000622035 -0.00069979 -0.000777544 <colgroup><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

Hi all,

I have an issue with the subtracting of the values from column 1 and 2 of each row of values respectively.
For e.g. Taking Row 1 values, (0.002456706+(-7.77544E-05)) = Value
Is there anyone who could guide me on how to code for this type of calculation? Thank you.

Best Regards,
Benjamin Lim

 

[onlyadrafter]

Hello,

what issue are you having? Why do you need code?

Looks like =A1-B1 should suffice.

Why do say subtracting the values then have + in the formula?

Would =IF(B1<0,A1+B1,A1-B1) work?

Do you need to subtract the value, but ignore the -

So if A1 = 2 and B1 -1, you actually want 2-1?