cell with highest value g5 would be upto 80=1,81:160=1.5,

a2=40,b2=200,c2=40,d2=32,e2=63
g5 would take the highest vlaue upto 80 would
=1,81:160=1.5,161:330=2,331:480=2.5,481:630=3,631:710=4,711:890=5,891:1070=6

=if(or(max(A2:E2)<1,max(A2:E2)>1070),0,VLOOKUP(MAX(A2:E2),{0,1;81,1.5;161,2;331,2.5;481,3;631,3.5;711,5;891,6},2,TRUE))

--
Regards,
Tom Ogilvy


"[email protected] uk" wrote:

> a2=40,b2=200,c2=40,d2=32,e2=63
> g5 would take the highest vlaue upto 80 would
> =1,81:160=1.5,161:330=2,331:480=2.5,481:630=3,631:710=4,711:890=5,891:1070=6