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

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.

Charles Williams commented
My addin product FastExcel Manager Pro for Mac has a better Evaluate Formula tool than Windows Excel (Formula Explorer Pro).
http://www.decisionmodels.com/fxl_MgrProMac.htmBut its a chargeable product

Anonymous commented
Poor communication: since 1.5 years MS is silent, not providing any status update. And the targeted customers of this feature are Excel's power users, not those, who actually don't care which spreadsheet app they are using.

Jan Gunn commented
Can we please have this feature added. It is so critical to using complicated excel formula successfully. Thank you.

Anonymous commented
This feedback was taken in 2015. We are nearly coming to 2020, MS still hasn't added anything at all. Evaluate Formula is a really important thing for me and I am really struggling without it!!

E commented
Is this update still coming?

Chris McKulka commented
So glad they added the "Sketch it Out" feature to Mac Excel (Give a casual, handdrawn look to Office shapes in your presentation.) which is gimmicky and I suspect few people care about about versus completing this long requested and critical feature. 😡️
So frustrating!