a1=raju b1=2 c1=3 d1=b1&if(a1="raju",+,-)&c1 This is not working,why?.How to do it?
T TUNGANA KURMA RAJU Sep 2, 2006 #1 a1=raju b1=2 c1=3 d1=b1&if(a1="raju",+,-)&c1 This is not working,why?.How to do it?
D Dave Peterson Sep 2, 2006 #4 You can't build formulas as strings like this and have excel evaluate them. (you could create a userdefined function that could evaluate any string, though.) But I'd use something like: =B1+IF(A1="raju",1,-1)*C1 or even =B1+IF(A1="raju",C1,-C1)
You can't build formulas as strings like this and have excel evaluate them. (you could create a userdefined function that could evaluate any string, though.) But I'd use something like: =B1+IF(A1="raju",1,-1)*C1 or even =B1+IF(A1="raju",C1,-C1)
