Questions

Help with Excel nested function

+
0 Votes
Locked

Help with Excel nested function

liz749
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!
+
0 Votes
cleaverx

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

+
0 Votes
cleaverx

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