IF() function on Date Format

[Clarence Crow]

Hello

I have an estimate workbook with a Management Summary up front of
numerous Tabbed detailed worksheets.

At the top of the Management Summary Sheet I have the Date shown with
=TODAY() and in the cell to the right I have a text entry "Floating"

When the Management have completed any adjustments, I Copy the Date
and Paste Special/Values over itself and then type a text entry
"Fixed" where "Floating" was.

I was wondering if there was an IF() function that would make the text
entry change from "Floating" to "Fixed" and the Syntax for it?

Clarence

 

[J.E. McGimpsey]

One way:

If you use David McRitchie's HasFormula() UDF

http://www.mvps.org/dmcritchie/excel/formula.htm#hasformula

then you can put this in B1:

=IF(HasFormula(A1),"Floating", "Fixed")