Hi Guys...

looking for a quick answer on excel Formula..

Anyone know why my text "Please Chase" is not showing up?

=IF(ISNUMBER(F2),$F2>TODAY(),"Please Chase")

Recommended Answers

Well, what's in cell F2?

Jump to Post

All 3 Replies

Well, what's in cell F2?

What are you trying to accomplish with this formula?

If F2 contains a date you'll always get a False value in the cell that contains the formula. If the value is any sort of numeric value you'll get the "Please Chase" value in the cell that contains the formula. Is this what you want?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.