Thread: Formula Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default 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