So here's what I'd like to do:
a1 would contain text like this:
2500*2
b1 would contain the result of a1, so:
5000
So the user of the spreadsheet (i.e., someone from management who doesn't want to fumble around with the formula bar) should have the ability to change the equation in a1 to whatever he/she wants, and the result in b1 would follow it.
Can someone help?
Thanks!
Bookmarks