ExcelBanter - Is this possible in excel ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is this possible in excel ? (https://www.excelbanter.com/excel-discussion-misc-queries/108242-possible-excel.html)

TUNGANA KURMA RAJU

Is this possible in excel ?

a1=raju
b1=2
c1=3
d1=b1&if(a1="raju",+,-)&c1
This is not working,why?.How to do it?

Toppers

Is this possible in excel ?

Is this what you want?

=if(a1="raju",b1+c1,b1-c1)

"TUNGANA KURMA RAJU" wrote:

a1=raju
b1=2
c1=3
d1=b1&if(a1="raju",+,-)&c1
This is not working,why?.How to do it?

Gary''s Student

Is this possible in excel ?

=IF(A1="raju",B1+C1,B1-C1)

Gary's Student

"TUNGANA KURMA RAJU" wrote:

a1=raju
b1=2
c1=3
d1=b1&if(a1="raju",+,-)&c1
This is not working,why?.How to do it?

Dave Peterson

Is this possible in excel ?

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)

TUNGANA KURMA RAJU wrote:

a1=raju
b1=2
c1=3
d1=b1&if(a1="raju",+,-)&c1
This is not working,why?.How to do it?

--

Dave Peterson

All times are GMT +1. The time now is 06:33 AM.