software

=IF('Natl Rank'!C1=quot;Month of March 06quot;,quot;quot;=VALUE('1'!C9)) ???? Not right.....

If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I want to
reveal the quot;valuequot; of spreadsheet tab 1, cell C9, in spreadsheet Natl Info,
cell B61.
--
Rebecca

quot;Rebeccaquot; gt; wrote in message
...
gt; =IF('Natl Rank'!C1=quot;Month of March 06quot;,quot;quot;=VALUE('1'!C9)) ???? Not
gt; right.....
gt;
gt; If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I want
gt; to
gt; reveal the quot;valuequot; of spreadsheet tab 1, cell C9, in spreadsheet Natl
gt; Info,
gt; cell B61.

=IF('Natl Rank'!C1=quot;Month of March 06quot;,'1'!C9,quot;quot;)
should do.
VALUE doesn't in general do anything for you (look at the help for the
function).
Your pair of double quotes amp; equals before the VALUE will probably have
confused the formula.
If you want the cell blank for anything other than quot;Month of March 06quot; in
C1, you need the quot;quot; for the false condition.
--
David Biddulph

rebecca,

In Natl Info B61

=IF('Natl Rank'!C1=quot;Month of March 06quot;,'1'!C9,quot;quot;)

Assuming that your sheet tab 1 is named quot;1quot;. 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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=530567David,

I will be changing the quot;Month of March 06quot; 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?
--
Rebeccaquot;David Biddulphquot; wrote:

gt; quot;Rebeccaquot; gt; wrote in message
gt; ...
gt; gt; =IF('Natl Rank'!C1=quot;Month of March 06quot;,quot;quot;=VALUE('1'!C9)) ???? Not
gt; gt; right.....
gt; gt;
gt; gt; If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I want
gt; gt; to
gt; gt; reveal the quot;valuequot; of spreadsheet tab 1, cell C9, in spreadsheet Natl
gt; gt; Info,
gt; gt; cell B61.
gt;
gt; =IF('Natl Rank'!C1=quot;Month of March 06quot;,'1'!C9,quot;quot;)
gt; should do.
gt; VALUE doesn't in general do anything for you (look at the help for the
gt; function).
gt; Your pair of double quotes amp; equals before the VALUE will probably have
gt; confused the formula.
gt; If you want the cell blank for anything other than quot;Month of March 06quot; in
gt; C1, you need the quot;quot; for the false condition.
gt; --
gt; David Biddulph
gt;
gt;
gt;

Steve.

I will be changing the quot;Month of March 06quot; 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

--
Rebeccaquot;SteveGquot; wrote:

gt;
gt; rebecca,
gt;
gt; In Natl Info B61
gt;
gt; =IF('Natl Rank'!C1=quot;Month of March 06quot;,'1'!C9,quot;quot;)
gt;
gt; Assuming that your sheet tab 1 is named quot;1quot;. This returns a blank if
gt; the condition is not true. It looks like you had the value if true and
gt; value if false reversed.
gt;
gt; Does that help?
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=530567
gt;
gt;

Rebecca,

I'm not David but do you have a date anywhere in the sheet? If not place a
date in an unused cell - say N1 - and if you don't want it to show either
hide the Column or Row, or change the font colour to the background colour.

Then use the formula:

=quot;Month of quot;amp;text(N1,quot;mmmm yyquot;)
to return quot;Month of March 06quot;

then:
=IF(TODAY()gt;'Natl Rank'!N1,'1'!C9,quot;quot;)
to replace your formula and when the date passes March 1st 2006 C9 will be
displayed and remain.

--
HTH

Sandy
In Perth, the ancient capital of Scotland

with @tiscali.co.ukquot;Rebeccaquot; gt; wrote in message
...
gt; David,
gt;
gt; I will be changing the quot;Month of March 06quot; cell to the following month
gt; each
gt; month. How can I get the value that had been pulled in by this formula to
gt; remain in the cell after this cell is changed. I have set up the same
gt; formulas for each month of the year in subsequent cells but I need the
gt; previous information to remain after the month name has changed in this
gt; cell.
gt; Any ideas?
gt; --
gt; Rebecca
gt;
gt;
gt; quot;David Biddulphquot; wrote:
gt;
gt;gt; quot;Rebeccaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; =IF('Natl Rank'!C1=quot;Month of March 06quot;,quot;quot;=VALUE('1'!C9)) ???? Not
gt;gt; gt; right.....
gt;gt; gt;
gt;gt; gt; If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I
gt;gt; gt; want
gt;gt; gt; to
gt;gt; gt; reveal the quot;valuequot; of spreadsheet tab 1, cell C9, in spreadsheet Natl
gt;gt; gt; Info,
gt;gt; gt; cell B61.
gt;gt;
gt;gt; =IF('Natl Rank'!C1=quot;Month of March 06quot;,'1'!C9,quot;quot;)
gt;gt; should do.
gt;gt; VALUE doesn't in general do anything for you (look at the help for the
gt;gt; function).
gt;gt; Your pair of double quotes amp; equals before the VALUE will probably have
gt;gt; confused the formula.
gt;gt; If you want the cell blank for anything other than quot;Month of March 06quot; in
gt;gt; C1, you need the quot;quot; for the false condition.
gt;gt; --
gt;gt; David Biddulph
gt;gt;
gt;gt;
gt;gt;