=IF(ISNUMBER(A2),1,IF(ISNUMBER(B2),2,IF(ISNUMBER(C 2),3)))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Mifty" wrote in message
...
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