Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Struggling IF value
=IF('Natl Rank'!C1="Month of March 06",""=VALUE('1'!C9)) ???? Not right.....
If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I want to reveal the "value" of spreadsheet tab 1, cell C9, in spreadsheet Natl Info, cell B61. -- Rebecca |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Struggling IF value
"Rebecca" wrote in message
... =IF('Natl Rank'!C1="Month of March 06",""=VALUE('1'!C9)) ???? Not right..... If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I want to reveal the "value" of spreadsheet tab 1, cell C9, in spreadsheet Natl Info, cell B61. =IF('Natl Rank'!C1="Month of March 06",'1'!C9,"") should do. VALUE doesn't in general do anything for you (look at the help for the function). Your pair of double quotes & equals before the VALUE will probably have confused the formula. If you want the cell blank for anything other than "Month of March 06" in C1, you need the "" for the false condition. -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Struggling IF value
rebecca, In Natl Info B61 =IF('Natl Rank'!C1="Month of March 06",'1'!C9,"") Assuming that your sheet tab 1 is named "1". This returns a blank if the condition is not true. It looks like you had the value if true and value if false reversed. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=530567 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Struggling IF value
David,
I will be changing the "Month of March 06" cell to the following month each month. How can I get the value that had been pulled in by this formula to remain in the cell after this cell is changed. I have set up the same formulas for each month of the year in subsequent cells but I need the previous information to remain after the month name has changed in this cell. Any ideas? -- Rebecca "David Biddulph" wrote: "Rebecca" wrote in message ... =IF('Natl Rank'!C1="Month of March 06",""=VALUE('1'!C9)) ???? Not right..... If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I want to reveal the "value" of spreadsheet tab 1, cell C9, in spreadsheet Natl Info, cell B61. =IF('Natl Rank'!C1="Month of March 06",'1'!C9,"") should do. VALUE doesn't in general do anything for you (look at the help for the function). Your pair of double quotes & equals before the VALUE will probably have confused the formula. If you want the cell blank for anything other than "Month of March 06" in C1, you need the "" for the false condition. -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Struggling IF value
Steve.
I will be changing the "Month of March 06" cell to the following month each month. How can I get the value that had been pulled in by this formula to remain in the cell after this cell is changed. I have set up the same formulas for each month of the year in subsequent cells but I need the previous information to remain after the month name has changed in this cell. Any ideas? -- Rebecca -- Rebecca "SteveG" wrote: rebecca, In Natl Info B61 =IF('Natl Rank'!C1="Month of March 06",'1'!C9,"") Assuming that your sheet tab 1 is named "1". This returns a blank if the condition is not true. It looks like you had the value if true and value if false reversed. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=530567 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help, I've been struggling for weeks! | Excel Worksheet Functions | |||
Struggling for a solution | Excel Worksheet Functions | |||
Struggling Again With A VLOOKUP | Excel Worksheet Functions | |||
Help, I'm Struggling! | New Users to Excel | |||
Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions |