Thread
:
IF(OR - IF(AND // Formula Help
View Single Post
09-06-2017, 11:12 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 932
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))
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets