id="info"

Question

Locked

Help with Excel nested function

By 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!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Help with nested functions...

by cleaverx In reply to Help with Excel nested fu ...

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

Collapse -

More help with nested functions

by cleaverx In reply to Help with Excel nested fu ...

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

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums