if you are getting excel #N/A errors the just use iferror
iferror(yourformula,"")