In that case, use this
=LOOKUP(A14,{0,8.1,10.1,12.1,14.1,16.1,18.1,20.1,2 5.1,28.1,30.1,32.1},{8,10,12,14,16,18,20,25,28,30, 32,"Error"})

you may change 8.1 to 8.001 if you have values like 8.05...


"raj74" wrote:

Thanks, but probably I wrote little bit wrong in expressing the algorithm.
Corrected will be
THKcal (lesss or equal) =< 8, Thk Provided, THKprov = 8
8< THKcal =<10 THKprov
= 10

And So on.

In your case if thk calculated is 8mm, thickness is coming 10mm which should
be 8 mm.

Regards




"Sheeloo" wrote:

Use
=LOOKUP(A1,{0,8,10,12,14,16,18,20,25,28,30,32},{8, 10,12,14,16,18,20,25,28,30,32,"Error"})

where A1 contains the THKcal value... It will give show ERROR if A1 has the
value 32 or above

"raj74" wrote:

I have to express the following logic.

Available Plate Thickness 8, 10, 12, 14, 16, 18, 20, 25, 28, 30, 32

The logic is if my calculated thickness is, THKcal < 8, Thk Provided,
THKprov = 8

8< THKcal <10
THKprov = 10

10< THKcal <12
THKprov = 12


.......................... ................


........................ ....................

28< THKcal <30
THKprov = 30

30< THKcal
THKprov = 32

Now this logic I have tried as
=if(THKcal<8,8,if(and(8<THKcal,THKcal<10),10,if(an d(10<THKcal,THKcal<12),12,........................ if(and(28<THKcal,THKcal<30),30,32))...)
But problem is I can no go beyond certain amount of limit for the nested loop.
What is the solution. Any easier way to express it. Anyway thanks.

Regards