Skip to main content
G
gbradley1-Visitor
1-Visitor
September 1, 2014
Solved

RE:change text in a formula

  • September 1, 2014
  • 1 reply
  • 3223 views

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

Best answer by MoeSzyslak

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'.

Capture.PNG

1 reply

M
MikeArmstrong1-Visitor
1-Visitor
September 1, 2014

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?

G
gbradley1-VisitorAuthor
1-Visitor
September 1, 2014

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.

M
MikeArmstrong1-Visitor
1-Visitor
September 1, 2014

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.

Terms & ConditionsAccessibility statement