freckles527
New Member
- Joined
- Apr 3, 2009
- Messages
- 6
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.
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.