Struggling IF value

"Rebecca" <[email protected]> wrote in message
news:[email protected]...
> =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

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" <[email protected]> wrote in message
> news:[email protected]...
> > =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
>
>
>

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:

="Month of "&text(N1,"mmmm yy")
to return "Month of March 06"

then:
=IF(TODAY()>'Natl Rank'!N1,'1'!C9,"")
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

[email protected]
[email protected] with @tiscali.co.uk


"Rebecca" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > =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
>>
>>
>>