Member Avatar for sundog1

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")

  • 3 Contributors
  • 3 Replies
  • 104 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Stuugie
Member Avatar for gusano79

Well, what's in cell F2?

Member Avatar for Stuugie

What are you trying to accomplish with this formula?

Member Avatar for Stuugie

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 meeting, networking, learning, and sharing knowledge.