Sep 1, 2023 · Here are some potential reasons why these formulas might not be working and how to fix them: 1. Function Disabled or Not Recognized: • Ensure that the OFFSET and INDIRECT functions are not disabled in your Excel settings. Go to "File" > "Options" > "Formulas" > "Working with formulas" and make sure "Enable Iterative Calculation" is checked.

Jan 13, 2020 · 1) If I create the formula in another workbook and paste it into the non-working one, then it will calculate. 2) If I use the replace function to replace all of the = with =. This was a solution that I found on another thread. This tells me that it is not a formatting issue.

Dec 17, 2019 · are supposed to work on the Office 365 E5 version but are not working for me along with many others. We tried various trouble shooting such as trying a different browser (Chrome or Safari) with no luck. The technicians sent me to this forum as they say they do not know how to resolve the issue. Please help as I need to implement this package ...

Mar 23, 2023 · It sounds like the Formula AutoComplete feature may be disabled in your Excel for Mac. Open Excel for Mac > Go to Preferences > View > Check the "Function ScreenTips" Please check here for more solutions: 1.

Oct 16, 2024 · Also, make sure both cells are formatted the same way. Sometimes Excel treats one as text and the other as a number, which causes issues. Right-click on the cells, choose "Format Cells," and set both to Text. This should help your formula work properly.

Sep 16, 2014 · I'm not sure what I'm doing wrong but Excel won't show me the function result, just the function itself on TODAY or NOW. I haven't tried the other functions, so maybe they aren't working either.

Apr 21, 2023 · I am running the Mac version of MS 365 excel on a MacBook (running Ventura). I have gone back to previous workbooks where it has worked in the past. If I try to add to an existing worksheet, this function now does not work! As I normally link multiple worksheets within a workbook this has become a real issue.

Jan 14, 2025 · Remark: this formula will cause calculations to be slow. It'd be better to use more limited ranges if possible. --- Best wishes, HansV https://www.eileenslounge.com

Feb 23, 2022 · I think there is an issue with my >= (greater than or equal to) function.I have a formula to catch the L and W individuals, to only add them to the group (1) if they are at or above a 4.0 in the

Jan 14, 2025 · So I decided to create a new worksheet from scratch copying the very first formula entry from the old worksheet, but my new worksheet still does not work. I'm not sure what has happened. I am using the latest MS Office 360 Home. I have attached an example of the new formula and would just like to know if this looks correct.