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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - cell with highest value g5 would be upto 80=1,81:160=1.5, (https://www.excelbanter.com/excel-programming/364162-cell-highest-value-g5-would-upto-80%3D1-81-160%3D1-5-a.html)

[email protected] uk

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

Tom Ogilvy

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

All times are GMT +1. The time now is 11:48 AM.