Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting a maximum value from a series of values

Status
Not open for further replies.

maloneb

Mechanical
Aug 11, 2011
22
Hey guys.

I have a list of 6 different calculated values which can all vary depending on the inputs. From this point in the sheet the maximum value must be used with the others becoming redundant. How do I write in code to selesct the maximum value to use from there on out?

Cheers

 
Replies continue below

Recommended for you

Oh, never mind!! I've cracked it!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor