How to find Minimum and Maximum value in calculated Range

[ptc-5029428]

Dear Experts,

I hope i'm in the right room/community for seeking this help.

Currently i'm working on a calculation which involves in a range (both input and output) and the range is quite large for example from 0m to 35000m.

I have a problem in determining the minimum and maximum value within this range.

Appreciate if someone could help me out on this.

attached is an extract from my actual calculation sheet as the iteration process do takes time.

so basically the LspanFE (x) is what i have caluclated (i just extracted it). As said x is from 0m, 10m ..35000m.

Look forward to hear from you guys soon.

Regards

-Akmal-

[ptc-5029428]

Dear Experts,

for better understanding to my problem, here i attached some parts of the related equations and etc.

Hope somebody could help me on this matter.

Thank you

Regards

-Akmal-

[AlanStevens · Accepted solution]

The attached should help.

Alan

[ptc-5029428]

Dear Alan,

Thank you. It does help.

-Akmal-