Need to hide #value error

[tHE fLY]

hey everyone,

I m having trouble getting this formula to work.


=IF(O9="X","N/A",IF(OR(P50="X",Q49>0,O49>0),IF(L29-E66<365),"N/A",E66+365),"N/A"))

tHIS IS REFERRING TO START DATS AND END DATES based on if he date is not blank. I am wanting to show he cell as a BLANK or "N/A" but keep getting a #VALUE! ERROR

ANY HELP WOULD BE APPRECIATIVE

 

[wrightyrx7]

Maybe IFERROR?

You havnt pasted your full formula for me to check.

 

[tHE fLY]

that is the whole formula.. looks like I left the F off of IF after the =