Building a rank table using If
 

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

Building a rank table using If
 

=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

Building a rank table using If
 

Hi Bernard,

This is just what I need.

Many thanks
--
Mifty


"Bernard Liengme" wrote:

=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