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

result to be either scalar or text

  • February 21, 2022
  • 1 reply
  • 2166 views

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

Best answer by EN_9902818

Hi,

 

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

 

Cheers,

Eleni

1 reply

E
EN_99028181-VisitorAuthorAnswer
1-Visitor
February 21, 2022

Hi,

 

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

 

Cheers,

Eleni

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

image.pngimage.png

t.t.
E
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

Terms & ConditionsCookie settingsAccessibility statement