Skip to main content
EN_99028181-Visitor
1-Visitor
February 21, 2022
Solved

result to be either scalar or text

Hi guys,

 

I'm trying to do a simple calculation of the middle third rule. What I want to achieve is shown in the spreadsheet but the issue is that if the condition ex/L+ey/B<1/6 is met only then I want the program to calculate the pressure otherwise just get a message like "N/A". Can the result be either a scalar or a text? I tried to put be a scalar with "N/A" for each of its elements but got an error message again, it seems that it accepts only numerical values

 

Any help will be much appreciated!

 

cheers,

Eleni

EN_9902818Answer
1-Visitor
February 21, 2022

Hi,

 

I put it in a program and find the solution. Thanks anyway.

 

Cheers,

Eleni

View in thread

5 replies

EN_99028181-VisitorAuthorAnswer
1-Visitor
February 21, 2022

Hi,

 

I put it in a program and find the solution. Thanks anyway.

 

Cheers,

Eleni

Translate
ttokoro
ttokoro21-Topaz I
21-Topaz I
February 21, 2022

image.pngimage.png

Translate
t.t.
EN_99028181-VisitorAuthor
1-Visitor
February 22, 2022

Hi,

 

Strange how this works. So if I use the equal sign to the variable definition, I got an error saying that the variable should be a scalar or a matrix but if I don't and just write in a different row the variable, I go the correct message! But then, I don't get the Pressure although I have define it inside the program.

Any idea why this happens?

 

cheers,

Eleni

Translate
Terms & ConditionsAccessibility statement