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]
Can we speed up the planning process? Because I feel like this is a simple add and not something that takes 5 years to add to Excel for Mac. Thanks, Steve K.
If you need help, then I think you could hire anyone of the 720 people to help you work/test this feature on this thread.
I hope all 720 of you vote for:
Its been 5 years since this struggle guys!
Technology is going outerspace and we are still cripplied by favoritism in developing adequate software capabilities.
Does it take 2 years to just plan this feature?
Have you added it yet and kept it invisible just to ***** with us?
Ha ha. I'm yet waiting for 2 years and I will spend at least 2 years more ?
Spencer Engel commented
Is this happening soon or what? I was very surprised to find it's still not available for Mac.
How can this possibly take so long for a feature which is standard in the windows version?
Adam Reid commented
Was staggered to find out that this wasn't included in Excel for Mac. It is essential when checking for any errors in a spreadsheet. The product owner comment about states that it is in the planning stages and this was more than 2 years ago. Surely it doesn't take 2+ years to plan the integration of an ALREADY EXISTING FEATURE in a version of your programme.
Extremely annoyed and cannot see a reason for this other than someone at Microsoft having the crazy idea that this will make someone switch to a Windows PC
Eddie Zhang commented
WPS Office has this feature. It's free and a perfect replacement for Microsoft Office Suite.
Evaluate Formula is an absolutely essential feature of excel. Its impossible to get your formulas right without it. Microsoft, are you thinking that withholding this feature will convert people to Windows? Don't be ridiculous.
To the folks proposing using arixcel: come on guys, it only works on windows. Why are you wasting people's time?
Help says that this option is available, but it is not. That is such weak programming and discourteous to your users. Get this done or update Help, so you aren't sending your customers on a wild goose chase.
I notice that the status of this was planned, back in March 2018. It's now June 2020. What is the latest status of this please? It should not take two years to move from planned to completed!
geoff pope commented
Being able to add a button, so that a value can be updated on a separate sheet. Currently I have to go to windows do it there and then go back to Mac and then I can alter it.
Justin Watson commented
An alternative to the "Evaluate Formula" wizard is to expose the formula, highlight the section, and hold FN+F9. This will calculate it as if you were running through it in the "Evaluate Formula" wizard, except it does not carry you through the formula using the Order of Operations; which you'll need to know if you utilize this alternative route.
Justin Watson commented
It would be great to have this feature added; so comprehensive! Will you let us know what the hold up is?
I can't believe this function is still missing. Why it takes so long?
Gary Freeman commented
Why so long? It's been a standard feature in Windows Excel - what is it about a Mac that prevents a simple cut and paste to the code.
Microsoft promotes its great AI skills, yet can't manage the "bread and butter"
I'm also glad to see Evaluate Formula will be added to Mac! Just curious, why was it not already included in the first place? Windows already has it, so I was just wondering why they wouldn't have been added at the same time. No criticism of course - just trying to make sense of things. =)
Mark Longstreath commented
Its great to hear that you are planning to add this in for Mac. I just hope that its not sidelined behind the vaccination plans!