RE:change text in a formula

[gbradley]

can you change text based on a formula without using the if statment.

for example.

sf = if(design = LRFD, "resistance factor", "shear factor"

Can the above be done by another method?maybe programming

Thanks

[MikeArmstrong]

You could use one of the lookup features or the match feature. It would depend on what data you have. Could you provide an example?

[gbradley]

I'll try mike but its a bit hard hard to explain with what I'm trying to achieve.

I'm trying to change the text in an IF statement but there is a variable in the if statment which needs to be chnaged

for example this is what I've got.

sf1:=if(design="LRFD","Resistance factor for shear phi0.9", "safety factor for shear omega 1.67")

however phi0.9 and omega 1.67 are variables, this is the bit I'm struggling with, these bits of text need to change based on a selection from the user.

[MikeArmstrong]

You will need to break the string down and extract the unique part.

The attached sheet shows a collection of string functions which may be of use. I did not create them, I blieve the credit has to go to Stuart Bruff.

[RichardJ]

Does this help?

[gbradley]

almost. Where phi is written in text, is it possible to write the symbol for phi followed subscript. ϕ.b (b subscripted)

[Werner_E]

Gareth Bradley wrote:

almost. Where phi is written in text, is it possible to write the symbol for phi followed subscript. ϕ.b (b subscripted)

You can't have subscripts in a mathcad text string.

[MoeSzyslak · Accepted solution]

Sure you can -- you can have any unicode character in a MC text string. Unfortunately for the OP, there is no unicode for 'subscript b'.

[MikeArmstrong]

Nice spot Moe