I ran into a problem with a formula that should work according to Microsoft but it failed .
When such simple formula can fail for a 32KB Workbook, I am questioning myself is it wise to adopt new Microsoft function?
Is it better practise to rewrite a formula which should work in theory rather than find out why it can fail ?
How to know if rewriting formulas is the answer ? or is there other issue when my original formula is now working in same Workbook.
You are not telling (or showing) us exactly what you are trying to do. Show us the formula - along with some data - and explain what you expected and what you got.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It's always better to try and find out what is causing the formula to fail.
A simple formula is:
=SUM(A1:A10)
but you might find that this produces a result of zero. There is nothing wrong with the formula, so it indicates that something is wrong with the data in the range A1:A10 - perhaps you have data in that range which looks like numbers but may in fact be text values, and summing them will result in 0.
In this case the data is incorrect, rather than the formula.
Hope this helps.
Pete
I personally do not like to admit defeat and I will play with a formula until it does what it is supposed to. Gotta love OCD.
For Excel Web, SUM(--ISFORMULA(A1:A38)) did not return Value nor Error ; result is =SUM(--ISFORMULA(A1:A38))
This problem disappeared after performing below actions
- turning off AutoSave
- turn off Background in Advance Setting of Apps
- Close other Edge Tabs
- Close Desktop Apps
- Clear Edge Cache
- Reset OneDrive
- Turn off Office Sync pertaining OneDrive
How to find out if SUM function is more susceptable to Windows Environment?
Last edited by panes-rubrics; 12-20-2022 at 12:44 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks