=IF(ISBLANK Formula returning error

pawcoyote

New Member
Joined
Mar 5, 2012
Messages
42
Howdy,

I am working with the following formula in my spreadsheet.

=IF(ISBLANK(F3),"Never Reported",IF(OR(MONTH(TODAY())<MONTH(F3),YEAR(TODAY())<YEAR(F3)),"Not Reporting","Reporting"))

F3 has a formula in that cell as well which reports either a date or blank.

When a date is in the cell the formula works but when there is a blank the formula returns #VALUE !

I would like to know how I can get the Never Reported to show if the cell is Blank.

Thank you for any help!
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
Try

=IF(F3="","Never Reported",IF

F3 is not actually blank!
 

pawcoyote

New Member
Joined
Mar 5, 2012
Messages
42

ADVERTISEMENT

One follow up question if you do not mind.

=IF(F3="","Never Reported",IF(OR(MONTH(TODAY())<MONTH(F3),YEAR(TODAY()),<YEAR(F3)),"Not Reporting","Reporting"))

If my date in F3 is not returning the Not Reporting if the date is less than today. It looks like if it see's this year or this month it says reporting. I want to show anything less than today's date i.e 2/21/19 as not reporting... Any suggestions?
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
Not sure I follow, post the formula you are using & a sample of what is in F3 & what result you expect.

Note: If your formula contains < or > make sure there is a space either side of them when posting here, like =today() < A1
otherwise the formula won'y post correctly.
 

pawcoyote

New Member
Joined
Mar 5, 2012
Messages
42

ADVERTISEMENT

Hi,

I tried to put a space on the sides of the < or > that did not work. It keeps cutting off my formula. Also I do not see how I can upload a spreadsheet with my simple sample.
 

philwojo

Well-known Member
Joined
May 10, 2013
Messages
533
Click on the hashtag in the quick reply area and the post your formula between the "CODE" tags and it should post properly. If you want to put a file up you will need to use something like dropbox and then post a link, but a lot of people won't click on those type of links (Though some will).
 

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,961
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top