SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Returning a blank cell when data is not inputted yet.

Reply
Occasional Learner
Posts: 1

Returning a blank cell when data is not inputted yet.

I would like the cell to return a blank when a date has not been entered yet for this formula but can not seem to complete this formula to accomplish this. Please help

 

="QTR"& INT((MONTH(Table2[@[Observation Date]])-1)/3)+1

Super User
Posts: 11,343

Re: Returning a blank cell when data is not inputted yet.

Posted in reply to BeachJeep

Looks more like an Excel question than SAS. I would find a forum for Excel for this question.

Ask a Question
Discussion stats
  • 1 reply
  • 192 views
  • 0 likes
  • 2 in conversation