=IF(ISBLANK Formula returning error

[pawcoyote]

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!

 

[gaz_chops]

Try

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

F3 is not actually blank!

 

[pawcoyote]

Thank you so much! that did it..

Try

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

F3 is not actually blank!

 

[gaz_chops]

You're welcome.

 

[pawcoyote]

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]

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]

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]

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).

 

[gaz_chops]

As @philwojo said, also check my signature for options for posting a sample here.

 

[pawcoyote]

As @philwojo said, also check my signature for options for posting a sample here.

I downloaded the MrExcel HTML maker but it isn't creating anything. I tried to go to the youtube vid but that is no longer there.