Why are $ used in some formulas?

Beth Fantozzi 1

Can someone please explain the purpose of the "$" in this formula?

=IFERROR(DATEONLY($[End Date]$198) + "", "")

Is there a benefit to having those in there? I know the formula will run just fine without them, that's why I am asking. Thanks in advance!

DKazatsky2

Hi @Beth Fantozzi 1,

The use of the "$" anchors the formula so if you copy/past or drag it over, it will still refer to that exact cell. Without it, the columns/row would change based on the new location. In other words, if you dragged this down, and the "$" was not used, the formula would resolve to =IFERROR(DATEONLY([End Date]199) + "", ""). NOTE the row number change.

Hope this helps,

Thanks.