=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]

I had to put spaces between almost everything to get it to post...<month(f3),year(today())<year(f3)),"not reporting","reporting"))[="" code]<="" html=""></month(f3),year(today())<year(f3)),"not>

Weird!

So what are you trying to do?
Looks like if today is less than F3 then "NOT REPORTING" else " REPORTING"

 

[jtakw]

Hi,

Whenever posting a formula with the < "less than" sign that is followed by Any Alpha character (including function calls), put a Space After the < sign and the next character, like

=IF(A< B,1,0)

=IF(A< TODAY(),1,0)

=IF(OR(A< B,B>C,C<>D),1,0)

=IF(A<10,1,0)

 

[gaz_chops]

Hi,

Whenever posting a formula with the < "less than" sign that is followed by Any Alpha character (including function calls), put a Space After the < sign and the next character, like

=IF(A< B,1,0)

=IF(A< TODAY(),1,0)

=IF(OR(A< B,B>C,C<>D),1,0)

=IF(A<10,1,0)

Yes, but strangely it still wouldn't work!

 

[jtakw]

This is the formula from Post # 20, with Only a space after each < sign, with or without code tags:

=IF(F3"","NEVER REPORTED",IF(OR(MONTH(TODAY())< MONTH(F3),YEAR(TODAY())< YEAR(F3)),"NOT REPORTING","REPORTING"))

=IF(F3"","NEVER REPORTED",IF(OR(MONTH(TODAY())< MONTH(F3),YEAR(TODAY())< YEAR(F3)),"NOT REPORTING","REPORTING"))

 

[gaz_chops]

This is the formula from Post # 20, with Only a space after each < sign, with or without code tags:

=IF(F3"","NEVER REPORTED",IF(OR(MONTH(TODAY())< MONTH(F3),YEAR(TODAY())< YEAR(F3)),"NOT REPORTING","REPORTING"))

=IF(F3"","NEVER REPORTED",IF(OR(MONTH(TODAY())< MONTH(F3),YEAR(TODAY())< YEAR(F3)),"NOT REPORTING","REPORTING"))

Yes, but strangely it still wouldn't work earlier!

 

[pawcoyote]

It's not IDing the devices as Not Reporting if they fall within this year. It makes everything as reporting unless the year is something other than 2019. I want it to mark those that are not "Today" i.e. 2/21/2019 Not Reporting. If it is 2/21/2019 then it states Reporting. Does it matter if Column F is a formula (Index Match) from another worksheet?

Weird!

So what are you trying to do?
Looks like if today is less than F3 then "NOT REPORTING" else " REPORTING"

 

[gaz_chops]

Try it as

=IF(F3="","NEVER REPORTED",IF(F3=TODAY(),"REPORTING","NOT REPORTING"))

 

[Fluff]

The other option, when posting formulae that include < or > is to go advanced, then scroll down and in the HTML section select HTML off

=IF(A2<B2,TRUE,FALSE)

 

[pawcoyote]

That didn't work. It is showing all as Not Reporting or Never reported.

Try it as

=IF(F3="","NEVER REPORTED",IF(F3=TODAY(),"REPORTING","NOT REPORTING"))

 

[gaz_chops]

It changes for me! Is the below what you are expecting?

[TABLE="width: 261"]
<colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: xl63, width: 174, colspan: 2"]NOT REPORTING[/TD]
[TD="class: xl64, width: 87, align: right"]21/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl63, colspan: 2"]NOT REPORTING[/TD]
[TD="class: xl64, align: right"]01/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl63"]REPORTING[/TD]
[TD][/TD]
[TD="class: xl65, bgcolor: yellow, align: right"]22/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl63, colspan: 2"]NEVER REPORTED[/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl63, colspan: 2"]NOT REPORTING[/TD]
[TD="class: xl64, align: right"]01/12/2018[/TD]
[/TR]
[TR]
[TD="class: xl63, colspan: 2"]NOT REPORTING[/TD]
[TD="class: xl64, align: right"]01/09/2018[/TD]
[/TR]
</tbody>[/TABLE]