Hi
I'm trying to write a function where when you input a value in 1 cell, the
formula will check the number and return a value in another cell.
So far I have this:
=LOOKUP(A5,{60,100,150,200,250,300,350,400,450,500 ,600,700,750,800,900,1000,1250,1500,1750,2000},{0. 3,0.46,0.64,0.79,0.94,1.07,1.21,1.4,1.59,1.78,2.15 ,2.52,2.71,2.9,3.27,3.64,4.52,5.4,6.28,7.16}
This is all very well but I want it to test for less than or equal to for
every value in the first array, putting <= next to the numbers generates an
error. I've tried using brackets but still it errors any help would be
gratefully appreciated