Taking the Max Value from 3 Calculation Results

**eocsur** · 02-19-2015, 01:46 PM

Hello everyone,

I have 3 calculations as seen below:

Please Login or Register  to view this content.

I would like to find the largest Nu(1), Nu(2) or Nu(3) for each 'i' in my loop.

Any help would be greatly appreciated

Best wishes,

Sarah

**Bernie Deitrick** · 02-19-2015, 03:48 PM

Depends on what you want to do with it.

You can calculate it directly:

Please Login or Register  to view this content.

or calculate it on the sheet in another cell:

Please Login or Register  to view this content.

**eocsur** · 02-19-2015, 04:07 PM

I used the top one to calculate it directly and it worked perfectly, thank you so much

I had been struggling with that for quite a while!

Re: Taking the Max Value from 3 Calculation Results