Relate from one worksheet to another
 

Hi everyone
I have two worksheets : A and B
Each of them have the same size, but each field of B is making from fields
of workseet A.

I'd like that eg. field (A1 ) in B checking filed (A1) in A and

if (A1) A < 0.37 then A1(B) = 0
if (A1) A = 0.37 and < 1.73 then A1(B) = 1
if (A1) A = 1.73 and < 5.2 then A1(B) = 3
if (A1) A = 5.2 then A1(B) = 9

Because I am very beginner and I don't use excel very often please give me
advice how to do it.
Thanks

Great Thanks,
it works perfectly :)