Question for the Excel Experts

[Digital2k]

I have a cell (L2) with this formula: =NOW(). and this format: "mmmm" to
show the current month.

I have another cell (H3) with this formula: =IF(L2="January",T10,).

The problem is cell (H3) is reading the formula and not the text.

How can I have the current month show in (L2) but have (H3) read the Text
and not the formula?

Please Help

Thanks, Digital2k

 

[Biff]

Hi!

Change the formula in L2 to:

=TEXT(NOW(),"mmmm")

The problem is cell (H3) is reading the formula and not the text.

The problem is/was that NOW( ) returns a NUMERIC value but you have
formatted it to look like the TEXT string JUNE.

Try this:

Enter =NOW() in an empty cell
Now, format that cell as GENERAL.
The value you now see is the cells true underlying value.

Biff

 

[Digital2k]

Thank You very much!!!

I love this Group!
Digital2k

 

[Biff]

You're welcome!

Biff

Thank You very much!!!

I love this Group!
Digital2k

 

[Dana DeLouis]

Hi. You've got an excellent solution. Just to mention another general
idea:

L2 = Now()

=IF(MONTH(L2)=7,"It's July",T10)