Thread
:
Formula Problem
View Single Post
#
1
Posted to microsoft.public.excel.programming
GregR
external usenet poster
Posts: 246
Formula Problem
What is wrong with this formula?
=IF(TEXT($B5,"mmm")"",TEXT($B5,"mmm"),"")
If B5 contains a date the answer is right, but if B5 is blank it still
returns a value. The expected result is if B5 is blank then C5 is
blank. TIA
Greg
Reply With Quote
GregR
View Public Profile
Find all posts by GregR