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
Bookmarks