Add Evaluate Formula to Mac app
Please add the evaluate formula dialogue box to the mac app. With it you can evaluate a formula step by step and see which part of the formula works and where the problem is.
Thanks for all your comments and votes supporting this suggestion. We are in the planning stages for this feature to be added to Excel for Mac.
Thanks – Steve K [MS Excel]
Waiting 5 years is far too long. (Issue was posted in 2015.) This ability should have been part of the initial MS Office for Apple (1992?). Maybe the answer is to petition Google or Apple to make certain upgrades to the free spreadsheet programs they provide.
I agree - this is really getting to be ridiculous. This should be an easy fix and is critical for us Mac users who really want to be a bigger user of MS Excel.
Please add. I know one of your young programmers can knock this out the park in a few days. Hey...why not make it a challenge similar to what Google does when recruiting.
captain dangerous commented
WELL...? We're Waiting.
We need to evaluate our formulas in Mac computers as well as you do in Windows.
Please add this feature into the Mac Excel software.
I can't believe a paying subscription like 365 excel for Mac won't support the same features for both platforms. Please add all the features for Mac since we end paying as users the same $$ to obtain an inferior service... :-(
Please bring this base function of Excel to the Mac!
It's such a mandatory tool, I can't even believe how MS dared to ship Mac versions without it for years and years. It's a shame Mac users don't get the same respect and care as PC users.
Come on! It's not a big deal, do it !!!
Pleeeeeeeeeeeeeeeeeeeeease, add this function.
Could someone from Microsoft please provide an update of when this is going to actually become available? It's ludicrous to think that this has taken 1.5 years to add. I have recently gotten a replacement laptop at work and I requested a MAC to replace my PC -- however based on the this deficiency I can't give back my PC if have to keep it to be able to debug formulas.
Hey, @Excel Team @ExcelTeam you would expect this to be standard functionality in Excel. So I ask if you think the users of the Mac version of Excel have different requirement to those that use the MS version.
Here is a quick definition of "What is Excel?": Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.
Surely this would be the same for Mac and Microsoft?
However, the issue in the Mac version is that Microsoft is making it really difficult (some might think deliberately so). Please note that Mac users need to use Excel for more than A1 = B1 + B2. I need "Evaluate Formula" to help me with issues in developing extensive and complicated formulae. Here is an example of one I created for a Client data processing tool today. Go ahead and put this into cell BH5 and test the formula for yourself......
oh my gosh, COME ON. We need this feature!!!! This is ridiculous.
Timothy H commented
Please, add this function.
Christian Kent commented
There's a blog post about feature parity on 2018-01-30 from Derek Snook, which really misled me: "Shared Office codebase for Windows, Mac, iOS, and Android means more features for more users faster" … I read that and assumed Windows features available pre-2015 were all on Mac. Was shocked to find this was not true after defending the honour of Office Mac while talking about "Evaluate Formula" with a friend who had come to me for help.
Please add it
Echoing most if not all comments below, why hasn't this feature been added and why aren't we getting updates on an ETA?
Neville Galappaththi commented
when will this be added? Are microsoft purposefully missing some features of excel from apple version so that to encourage us to buy PCs with windoors operating system?
Is is a business fraud.
O I cant understand why this basic Excel functionality is not being supported for MAC users
Please this feature should be added ASAP. It is so critical to using complicated excel formula successfully. Thank you.
Very disrespectful and embarrassing omission by Excel team... Shameful.
Evaluate formula is a mandatory feature in excel. There should not be any feature difference between excel for Mac and Windows. Please add it asap in Excel for Mac.