View Single Post
 
Old 09-06-2017, 11:12 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

On fly (I haven't Excel available currently):

In Min row, replace texts with numbers, p.e. +100 kg -> 100;

The formula will be
=MAX($D$11,CHOOSE(MATCH($B$2,$E$9:$J$9,1),$E$11:$J $11))
Reply With Quote