I am just picking up Excel, but have experience with R and Stata. Does Excel have a missing symbol convention? That is, does Excel have something like R's `NA`

or Stata's `.`

?

For example, I evaluate an `IF()`

statement and want to return a value that will be omitted from later calculations I use `"NA"`

. Is this the correct approach in Excel? It seems like I am missing a basic concept, but I can't get Google to give me a better answer.

To make this more concrete, I have a conditional like `=IF([@[Div Dummy]]=1,"NA",EOMONTH(A8,0))`

. Is there a way to get a numeric "missing value" placeholder so that I don't get warnings about conflicted data types?