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")
sundog1
0
Posting Whiz in Training
Recommended Answers
Jump to PostWell, what's in cell F2?
All 3 Replies
gusano79
247
Posting Shark
Well, what's in cell F2?
Stuugie
50
Marketing Strategist
What are you trying to accomplish with this formula?
Stuugie
50
Marketing Strategist
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.