Get Help

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- If function in Table

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-19-2018
01:42 AM

09-19-2018
01:42 AM

Hi there,

I am new to Mathcad tool and nowadays preparing a calculation sheet for Cantilever and Deflection Forces Analysis.

Please see attached herein my query with post.

Now at first column there are two cateogries for type of span and against some type of support is given. Respenctively there are three factors (a,b,y) which need to be considered depending upon these 1st and 2nd column's values. In column three, there are two more condition like point A and B as given above. So my query is that how can I or what function do I need to use here to execute the desired output based on these criteria.

I have just starting learning Mathcad so I am wondering if anyone from the communtiy help me to figure out the correct method.

Many Thanks,

Regards

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-19-2018
06:11 AM

09-19-2018
06:11 AM

Of the more than a million ways to do this, here's just one:

I'm assuming you are using Prime version 4 or higher, Prime 4 file attached.

Success!

Luc

8 REPLIES 8

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-19-2018
06:11 AM

09-19-2018
06:11 AM

Of the more than a million ways to do this, here's just one:

I'm assuming you are using Prime version 4 or higher, Prime 4 file attached.

Success!

Luc

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-20-2018
11:42 PM

09-20-2018
11:42 PM

Re: If function in Table

Thanks Luc. It helps. I would be interested to stay in touch with you for more lessons and useful solutions.

thanks again

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-24-2018
04:49 AM

09-24-2018
04:49 AM

Re: If function in Table

One question related to your given solution. Where in we are providing Getdata function and ("Value from Table"), Can we do something that here Stype: "Value" call it automatically instead of toching the formula, we defined its value somewhere as variable and the outputs change accordingly?

See in below firgure extreme top right an example variable.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-24-2018
05:40 AM

09-24-2018
05:40 AM

Re: If function in Table

Are you looking for this?

Success!

Luc

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-24-2018
06:00 AM

09-24-2018
06:00 AM

Re: If function in Table

Hi @LucMeekes,

Great. But only question is that your value A, B .. coming outside the matric form. How to do that. Reason been, I am using the division factor of these value further in my sheet including with IF statement, had it been in matrices form, the statement return to an error that value must be scaler.

Did you understand my problem here ?

thanks

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-24-2018
07:49 AM

09-24-2018
07:49 AM

Re: If function in Table

Apparently I did not understand your problem.

Please provide a worksheet with a clear indication of your problem. NOT (just) a picture.

Luc

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-25-2018
06:56 AM

09-25-2018
06:56 AM

Re: If function in Table

Hi @LucMeekes

Thanks buddy. I did this myself. Actually I did not convert matric to scaler thats why I was facing an issue in sheet.

I got the solution.

thanks

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-19-2018
10:22 AM

09-19-2018
10:22 AM

Re: If function in Table

And here's another:

Success!

Luc