=CELLNAME(A1) -> "A1" =CELLNAME(A1, YES) -> "$A$1"
DEFINE( CELLNAME, LAMBDA( [reference], [absolute?], LET( address, IFOMITTED( reference, CELL("address"), CELL( "address", reference)), display_absolute, DEFAULT( absolute?, NO), IF( display_absolute, address, SUBSTITUTE( address, "$", "")))))
Help us optimize this function