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]
82 comments

Anonymous commented
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.

Anonymous commented
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.

Miwuk3 commented
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.

Anonymous commented
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. 
Anonymous commented
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... :(

Anonymous commented
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 !!!

Alessio commented
Pleeeeeeeeeeeeeeeeeeeeease, add this function.

Anonymous commented
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.

Anonymous commented
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......
=IFERROR(IF(BG5,BG5,IF(AND(AV5=$BH$2,IF(IF(AW5=$AW$2,(BD5+BF5),BF5)<BD5,ROUNDUP(BD5,0),IF(AW5=$AW$2,ROUNDUP(BD5+BF5,0),ROUNDUP(BF5,0)))/AZ5<$BI$2),$BI$2*AZ5,IF(AND(AV5=$BH$3,IF(IF(AW5=$AW$2,(BD5+BF5),BF5)<BD5,ROUNDUP(BD5,0),IF(AW5=$AW$2,ROUNDUP(BD5+BF5,0),ROUNDUP(BF5,0)))/AZ5<$BI$3),$BI$3*AZ5,IF(AND(AV5=$BH$4,IF(IF(AW5=$AW$2,(BD5+BF5),BF5)<BD5,ROUNDUP(BD5,0),IF(AW5=$AW$2,ROUNDUP(BD5+BF5,0),ROUNDUP(BF5,0)))/AZ5<$BI$4),$BI$4*AZ5,IF(IF(AW5=$AW$2,(BD5+BF5),BF5)<BD5,ROUNDUP(BD5,0),IF(AW5=$AW$2,ROUNDUP(BD5+BF5,0),ROUNDUP(BF5,0))))))),"")

Anonymous commented
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 20180130 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 pre2015 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.

Bartek commented
Please add it

Steve commented
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. 
Emilio commented
O I cant understand why this basic Excel functionality is not being supported for MAC users

Anonymous commented
Please this feature should be added ASAP. It is so critical to using complicated excel formula successfully. Thank you.

Warren commented
Very disrespectful and embarrassing omission by Excel team... Shameful.

Jagadhees commented
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.