Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Receiving INCORRECT ARGUMENT SET when using an IFERROR
This is the error I'm receiving on my sheet summary page. Please note that the sheet is "set up" with columns and necessary formulas, there is just no information entered yet.
Every time I open this sheet, I get the error above. To fix this problem, I just copy the formula, delete it, then re-paste it.
This is after I re-pasted the same exact formula that was giving me an error.
The formula I am using is this. =IFERROR(MEDIAN([Contract Amount]:[Contract Amount]), "Calculation error. Contact Admin.")
This is the formula that I am using. I've looked it over it numerous times, it seems like a pretty simple formula that is hard to mess up on. Does IFERROR not account for #INCORRECT ARGUMENT SET? And why does repasting the same formula in the same exact field "fix the problem"? Shouldn't there also be a 0 in that field as well, since it's calculating nothing? Or should there be my message "Calculation error. Contact Admin."?
Any feedback is appreciated! Thanks!
Best Answers
-
If the sheet is completely blank/unused, then the cells are not just empty. They essentially do not exist. What happens if you put a number in a cell in the column you are pulling into the MEDIAN function?
-
IFERROR does not work on ALL errors. I used to have a list, but I can't seem to find it anymore. Basically it works for most, but there are some that will still push through such as the one you are experiencing, unparseable, and blocked.
Answers
-
If the sheet is completely blank/unused, then the cells are not just empty. They essentially do not exist. What happens if you put a number in a cell in the column you are pulling into the MEDIAN function?
-
If I enter a number in the referenced column, it calculates correctly.
-
Ok. In that case you can either leave it empty until the template is actually used knowing that the error will go away once in production, or you can insert a "placeholder row" that just holds fake data in the template.
-
Interesting. So I guess my question now is why is IFERROR not accounting for that? Does IFERROR only work when there is data inputted into the referenced range?
-
IFERROR does not work on ALL errors. I used to have a list, but I can't seem to find it anymore. Basically it works for most, but there are some that will still push through such as the one you are experiencing, unparseable, and blocked.
-
Got it, I did not know that. That is definitely useful information that I can use in the future.
Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summar…
