hi, i am trying to get a number value from within a formula. there are multiple copies of the same expressions within the formula (eg below), where, if possible: max for all values (between: ">" or "<" and: "," thanks in advance.

exampleS of the formula using is of varying lengths, eg anywhere from 3 to 10 or more expressions.

max of all would come up, if i were using a "less than" value sign: "<" thereby putting the max to the right of the examples. one single max output is all that is needed.

all numbers on first 2 lines are: 4 2 1.15 0.7 the 2nd & 3rd examples show embedded if thens if that matters.

=IF(A9>4,"X",IF(A9>2,"Z",IF(OR(A9>1.15,1),"Y",IF(OR(A9>0.7,0),"B","A"))))

=IF(A9>2,IF(A9>4,"X","Z"),IF(OR(A9>1.15,1),"Y",IF(OR(A9>0.7,0),"B","A")))

.

=IF(OR(A9>0.02,0*(B9=1)),IF(A9>5,"X",IF(A9>0.8,"ZAX",IF(A9>0.3,"XYZ",IF(A9>0.2,"ABX",IF(A9>0.1,"CBE","FAX"))))),

IF(OR(A9>0.01,0*(B9=1)),"XYZ",IF(OR(A9>0.005,0*(B9=1)),"XYZ",IF(OR(A9>0.001,1*(B9=1)),"X",IF(OR(A9>0.0005,1*(B9=1)),"ABC","AFN")))))

SUMPRODUCT(MAX ??

i have dozens of examples looking at but not sure any for formulas, most come up errors & am not sure where to start, bunch more than this but not clicking yet/ right now again how these work. (i added the left 13 on all of them)

=LEFT(FIND(MID(AO1552,(FIND(">",AO1552)+3),10),AO1552),13)

=LEFT(TRIM(LEFT(AO1562,FIND(">",AO1562)-1)),13)

=LEFT(--TRIM(LEFT(AO1562,FIND(">",AO1562)-1)),13)

=LEFT(MID(LEFT(AO1562,FIND(">",AO1562)-1),FIND(",",AO1562)+1,LEN(AO1562)),13)

=LEFT(MID(AO1562, FIND(">",AO1562)+1, FIND(",", AO1562, FIND(">", AO1562)+1)-FIND(">",AO1562)-1),13)

=LEFT(MID(AO1562,FIND(">",AO1562)+1,FIND(",",AO1562)-FIND(">",AO1562)-1),13)

=SEARCH(",",AO1562)-SEARCH(">",AO1562)-1