Why do I keep getting a pesky formula error message?

rjoberhofer 

Inquire add-in is not available for Excel on Mac, so far I know.

let's explore some additional troubleshooting steps to address the persistent formula error messages:

1. Check for Data Types: Ensure that the data types in your cells are consistent with the formulas you're using. For example, if you're performing calculations on numbers, make sure that the cells containing those numbers are formatted as numbers and not as text.
2. Review Formula Auditing Tools: Excel for Mac includes built-in tools for auditing formulas. You can use features like "Trace Precedents" and "Trace Dependents" to identify any cells that are influencing or influenced by the formulas in question. This can help you pinpoint the source of the errors more accurately.
3. Evaluate Formulas: Use the "Evaluate Formula" feature to step through your formulas and see the intermediate results at each stage of calculation. This can help identify where the errors are occurring and why.
4. Use Error Checking: Excel for Mac includes error checking features that can help identify and resolve formula errors. Go to the "Formulas" tab in the ribbon and click on "Error Checking" to see if there are any errors detected in your workbook.
5. Recreate Formulas: If you're still unable to identify the source of the formula errors, consider recreating the formulas from scratch. Copy the data to a new worksheet and rebuild the formulas one by one, checking for errors as you go.

By systematically going through these additional troubleshooting steps, you may be able to identify and resolve the formula error messages in your workbook. If you continue to experience difficulties, Welcome to your Excel discussion space!. My knowledge of Mac is limited.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.