> ## Documentation Index
> Fetch the complete documentation index at: https://artemis.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Artemis Sheets Formulas

#### Getting a "#NAME" error in a cell with an ART/ARTRANGE/ARTDUNE formula

<img src="https://mintlify.s3.us-west-1.amazonaws.com/artemis-db73460d/images/image%20(122).png" alt="" />

#### Cause

This happens if the Artemis Sheets add-in is not recognized / not installed.

#### Fix

* Check if the [Artemis Sheets add-in is installed](/artemis-sheets/troubleshooting/excel-on-windows-desktop/check-if-the-artemis-sheets-add-in-is-installed). If Artemis Sheets Excel Add-in is not present, you need to [install ](/artemis-sheets/troubleshooting/excel-on-windows-desktop/install-the-artemis-sheets-add-in)it.
* If the add-in is installed, you might need to [manually activate](/artemis-sheets/troubleshooting/excel-on-windows-desktop/manually-activate-the-artemis-sheets-add-in) it.

#### Getting a single value in a cell with an ARTRANGE/ARTDUNE formula

#### Cause

This happens if you have an Excel standalone license (not 365). [Dynamic arrays](https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531) support is available only in Excel 365.

#### Fix

* Use the classic [array formulas](https://support.microsoft.com/en-us/office/create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d) approach when inputting the ARTRANGE/ARTDUNE.