Automate calculations
How can automate a calculation in the following scenario:
Eg.
Column 1 = A
Column 2 = Maths operation eg. + / - / X / ./.
Column 3 = B
To automate calculation in column 4 = A + or - or X or ./. B depending on
what is keyed into column 2
Thank you in advance
|