Hi everyone,

I'm trying to extract data from a table on one worksheet and have it build a
table in another .

The data in sheet1 is arranged so that A is over 80% B is less than 80 but
more than 60% and so on.

I have been trying to put together an if statement saying that if there is a
number in A2 then Sheet2 C4 should return 1 if not, if there is a number in
B2 then C4 should be 2 etc.

I'm pretty sure I need a nested if statement so tried to build one up using
one if at a time, I didn't know how to say if not blank so used isnumber but
just got false.

Help!!!

--
Mifty