Building a rank table using If

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
=IF(ISNUMBER(A2),1,IF(ISNUMBER(B2),2,IF(ISNUMBER(C2),3)))
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking Table 2
Build a Table 2
somewhat complex if statement help PLEASE!!!! 1
Ranking in a Different Way 12
If, If, If, If, If ... 2
If AND query 5
List Bldg # according to sum of hours and bldg rank.... 3
Nested If 5

Back
Top