Lookup if statement

[DiViS]

Hi all,
what am i missing,

=LOOKUP(B5,{((>=0.36,<1.44),(>=1.44,<3.6),(>=3.6,<7.2),(>=7.2,<14.4),(>=14.4,<21.6))},{"10.5","10.2","9.9","9.3","8.7"})

basically first one is = if B5 >=0.36 and <1.44 then =10.5
and so on.

please help, its for work.
Thanks

 

[Michael M]

Maybe this

=IF(B5<1.44,10.5,IF(B5<3.6,10.2,IF(B5<14.4,9.9,IF(B5<21.6,9.3,8.7))))

 

[DiViS]

Dead set Legend you are mate.
cheers.

 

[Michael M]

I wish !!!.....

 

[jtakw]

Hi,

@Michael M, I think you missed a couple of cut offs, perhaps this correction to your formula, I might be wrong:

=IF(B5>=0.36,IF(B5<1.44,10.5,IF(B5<3.6,10.2,IF(B5<7.2,9.9,IF(B5<14.4,9.3,IF(B5<21.6,8.7,"Over"))))),"Under")

And the LOOKUP version if there might be Negative values in B5:

=IFERROR(LOOKUP(B5,{0,0.36,1.44,3.6,7.2,14.4,21.6},{"Under",10.5,10.2,9.9,9.3,8.7,"Over"}),"Negative")

If No negative values are possible in B5:

=LOOKUP(B5,{0,0.36,1.44,3.6,7.2,14.4,21.6},{"Under",10.5,10.2,9.9,9.3,8.7,"Over"})

 

[Michael M]

@jtakw...thanks for the pickup....See what happens without your glasses...

 

[jtakw]

I'm near sighted Just enough to not need reading glasses, my eye doctor tells me that's a good thing...