Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I do a RANK calculation in a Pivot Table | Excel Discussion (Misc queries) | |||
Building Pivot table from Access data | Excel Discussion (Misc queries) | |||
Rank in Pivot Table | Excel Worksheet Functions | |||
Building a table with formulas rather than a macro | Excel Worksheet Functions | |||
pivot table - Rank | Excel Discussion (Misc queries) |