Skip to main content
ppal_25568718-Opal
18-Opal
July 6, 2017
Solved

Help with Using Substitute Function.

Hi

I am having problems properly using the substitute function.

Could someone show me where I am going wrong?

 

 

 

 

 

simul.png

Werner_E
Werner_EAnswer
25-Diamond I
July 7, 2017

I experience no problems. Neither with MC15, nor with P30

noprob.pngMaybe something you did in the sheet and deleted later (have you tried to create those expression in a fresh sheet?) or you have found a newly introduced bug.

 

I guess its another annoying effect of Primes auto-labeling! Its not wrong to call that "feature" a bug - at least its a buggy feature.

Both "x" in the last expression must be labeled the same - either both "variable" or both "-" (automatic).

 

 

 

View in thread

3 replies

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
July 7, 2017

I experience no problems. Neither with MC15, nor with P30

noprob.pngMaybe something you did in the sheet and deleted later (have you tried to create those expression in a fresh sheet?) or you have found a newly introduced bug.

 

I guess its another annoying effect of Primes auto-labeling! Its not wrong to call that "feature" a bug - at least its a buggy feature.

Both "x" in the last expression must be labeled the same - either both "variable" or both "-" (automatic).

 

 

 

Translate
ppal_25568718-OpalAuthor
18-Opal
July 7, 2017

Worked when I cut and pasted your equation into my sheet and works when I started on a fresh sheet.

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
July 7, 2017

Check the labels of the "x" in your original sheet! (I can't as you use a newer version of prime thna mine and so I can't open your sheet).

Translate
Terms & ConditionsAccessibility statement