Want to make a table like below, after tons of research, kind get idea I probably need to use evaluate. Just don't know how. Appreciate any thoughts and help
So A1 will be math symbols '+', '-', '*', ...
B1,C1....A2,A3...row and columns will enter numbers
How can I write formula in B2 to make is calculate B1 + A2
NOTE, I Need formula to take the math symbols from A1 automatically, so if I change A1 from '+' to '-' whole sheet recalculate automatically
Dont know if I described clearly.
Thanks