Cell display

C

CrewDog130

I would like a to make the cell with the following formula display "N/A
or remain blank when a date is not entered in K4. Does anyone have an
suggestions?

=((TODAY()-K4)/365)*1
 
T

T. Valko

Try one of these:

=IF(COUNT(K4),(TODAY()-K4)/365*12,"N/A")

=IF(COUNT(K4),(TODAY()-K4)/365*12,"")
 
R

Rick Rothstein

I'm assuming when you say "when a date is not entered in K4" that you mean
K4 is blank)...

=IF(K4="","N/A",((TODAY()-K4)/365)*12)

or

=IF(K4="","",((TODAY()-K4)/365)*12)

depending on if you want N/A or the blank.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Criteria = 1 8
Regarding Word Add in on Office 365 0
=Large function returns #NUM! 5
Leave final cell blank 2
Adding dates in a IF Statement 2
M.S. Word 365 1
New Bug in Track Changes in Word 365 0
Help with a formmula change in a "flag" parameter! 19

Top