cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
BeachJeep
Calcite | Level 5 BeachJeep
Calcite | Level 5

Returning a blank cell when data is not inputted yet.

Posted 10-20-2016 12:46 PM (835 views)

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

0 Likes
Reply
1 REPLY 1
ballardw
Super User ballardw
Super User

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

Posted 10-20-2016 03:29 PM (820 views)  |   In reply to BeachJeep

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

0 Likes
Reply

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Watch How to connect to databases in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎10-20-2016 12:46 PM
  • 836 views
  • 0 likes
  • 2 in conversation