Formula for changing + & -

[JOHNJEN]

Hi All

consider two colum in one colum is to put if the numbers is of + or - (the simbol is entered manually ) i wanted the same courespondig vale in the next coulm which contains formula "A1 + B2"

Example

vale on A1 colum is "+" then on the next colum the formula should be automaticly changed to B1 + C1, simelteniously if A1 colum is entered "-" then the formula should be changed to B1 - C1.

Hope every one understood my query, Request your help ..

[samba_ravi]

can you attach sample file pls

[:) Sixthsense :)]

	a	b	c	d
1	+	44	10	54
2	-	44	10	34

	a	b	c	d
1	+	44	10	=if(a1="+",b1+c1,if(a1="-",b1-c1,""))
2	-	44	10	=if(a2="+",b2+c2,if(a2="-",b2-c2,""))

[ELeGault]

Please Login or Register  to view this content.

[JOHNJEN]

Thanks. " Sixthsense " Exactly what i wanted .
Thanks all for the fast response

[TMS]

@ELeGault: very clever and neat solution.

Kind regards, TMS

[ELeGault]

Thanks, Hopefully the OP took a look... Was the shortest solution I could come up with -

Was trying to make it run off any operator but after about 10 minutes I lost motivation.

Cheers

[TMS]

... but after about 10 minutes I lost motivation

I can see how that might be the case