use cell value as an operator in excel 2003 formula

[r1998]

Dear friends and respected seniors,
In excel 2003, i have this data in cells
a1 = 1
b1 = +
c1 = 2
In d1 i want calculation of a1 and b1 and c1, so answer in d3 must be 3, because 1+2=3.
Similarly if value in b1 is -, then d1 must become -1 because 1-2 = -1, but I am not able to do it
I tried these 2 formulas in d1, but not getting the answer as 3

=A1&B1&C1

n then this

="="&A1&B1&C1

Can anyone please kindly help me.
Awaiting your replies.
Thank you.

 

[James006]

Hello,

You need to follow a three step process :

1. Create your formula , say in cell D1 :

=CONCATENATE("=",A1,B1,C1)

2. Then in cell E1, you create a Named range for example result with the formula

=EVALUATE($D1)

3. And in cell E1, you type in the formula

=result

Hope this will help

 

[r1998]

Thank you James006

 

[James006]

Thank you James006

You are Welcome ...