IF Error or Conditional Formatting

[freckles527]

1st thank you for any help.

I have written formulas and used conditional formatting to hide error values. The specific one I am trying to hide is #Value!

I have a drop-down list in Column D that calculates a year result in Column E. This is based on using Defined Names.

Cell E formula is =IF(D6="","",INDEX(RP,MATCH(D6,RCC,0))). When my dropdown list in D is populated with a code, then E poulates with a year.

The user will put in an effective date in Column F. Column G calculates the Expiration Date from what populated in Column E.

Column G formula is: =DATE(YEAR(F6)+E6,MONTH(F7),DAY(F6)) this formula works and calculates the correct expiration date.

My issue is I have to copy all of these formulas down so the user doesn't have to remember to copy them or calculate the future date. I get a #Value! error.

I have tried using some ISERROR formulas, conditional formatting using ;;; and nothing is working.

 

[etaf]

Have you tried
=IFERROR()
=IFERROR(DATE(YEAR(F6)+E6,MONTH(F7),DAY(F6)),"")

 

[freckles527]

Hi etaf. I did try that and it isn't working. I will try it again in a new spreadsheet. Thank you for your reply.

 

[freckles527]

Got it finally - ugh. I thought I had tried this, but now it is working and leaves the cell blank if nothing is populated in F6.

=IF(F6<>"",(DATE(YEAR(F6)+E6,MONTH(F7),DAY(F6)),"")

 

[etaf]

=IF(D6="","",IFERROR(INDEX(RP,MATCH(D6,RCC,0)),""))

 

[etaf]

ok, glad its working OK now

 

[freckles527]

Thank you, everyone. I will copy the suggestions you provided. You never know when those are needed.