Hi everyone, I am new to nested functions and am trying to use the following:
=IF(NOT(OR(F3:H3)),"Do not include",IF(OR(AND(F3,NOT(OR(G3:H3))),AND(OR(G3),NOT(F3,H3))),"Get More Data","Allow to bid"))
I am getting the error "You've entered too many arguments for this function"
Any idea what I am doing wrong? Thanks!
- Follow via:
- RSS
- Email Alert
Question
Answers (2)
0
Votes
Help with nested functions...
Hello, sorry I don't have a ready answer for you, but you will probably stand a better chance of someone providing you with a solution, if you also explain what it is that you are trying to accomplish with this formula.
It may just be that the approach itself may need to be revisited.
Best regards
The Cleaver
It may just be that the approach itself may need to be revisited.
Best regards
The Cleaver
27th Sep
0
Votes
More help with nested functions
Hello again,
I found this forum where someone had an issue very similar to yours and received a very detailed explanation; maybe it will help you sort out your own problem:
http://www.excelforum.com/excel-general/824569-nested-if-function-error-youve-entered-too-many-arguments.html
Best regards
The Cleaver
I found this forum where someone had an issue very similar to yours and received a very detailed explanation; maybe it will help you sort out your own problem:
http://www.excelforum.com/excel-general/824569-nested-if-function-error-youve-entered-too-many-arguments.html
Best regards
The Cleaver
27th Sep
