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

Post your formula as Phil said, click on the # and paste it between the

 boxes.

Then explain what you are trying to do.

 

[pawcoyote]

The # doesn't help. It keeps breaking the Code at (TODAY()) It will not post the rest of the code. Bummer...

 

[gaz_chops]

strange! as a last resort, you can try posting a sample spreadsheet on drop box or similar, then post the link here.

 

[Gaurangg]

Check if below formula helps

=IF(OR(F3="",F3<TODAY()),"Not Reported",If(<today()),"not reported",if(<today()),"not="" reported",if...<="" html=""></today()),"not>

 

[philwojo]

When you post with the hashtag button it should generate two blocks one should show as

 and the other as [ / code ]  (without the spaces).

If you post your formula between those two "blocks" it should post just fine.  

You didn't type hashtag or #, correct?  I should have been more clear to hit that button in the reply section.

Phil

 

[gaz_chops]

This is from your 1st post, add the rest of the formula

=IF(f3="","Never Reported",IF(OR(MONTH(TODAY()) < month(f3),year(today())<month(f3),year(today())[ code]<="" html=""></month(f3),year(today())[>

 

[gaz_chops]

When you post with the hashtag button it should generate two blocks one should show as

 and the other as [ / code ]  (without the spaces).

If you post your formula between those two "blocks" it should post just fine.  

You didn't type hashtag or #, correct?  I should have been more clear to hit that button in the reply section.

Phil[/QUOTE]

I have the same issue if i paste the last formula between the [code] boxes, like

[CODE]=IF(f3="","Never Reported",IF(OR(MONTH(TODAY())<month(f3),year(today())

<month(f3),year(today())[ code]<="" html=""></month(f3),year(today())[>

 

[Gaurangg]

I am not sure why I am not able to paste the formula here

=IF(OR(D7="",D7<TODAY()),"Not Reported",If(

<today()),"not reported",1)<today()),"not="" reported",if(<="" html=""></today()),"not>

 

[gaz_chops]

I am not sure why I am not able to paste the formula here

<today()),"not reported",if(

Which is what we've been discussing for a while now

</today()),"not>

 

[pawcoyote]

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

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>