Thread: cell with highest value g5 would be upto 80=1,81:160=1.5,
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default cell with highest value g5 would be upto 80=1,81:160=1.5,
=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;71 1,5;891,6},2,TRUE))

--
Regards,
Tom Ogilvy


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
Reply With QuoteReply With Quote