• 587K Members
• 7,986 Online
• 712K Conversations
SOLVED

Highlighted
New Contributor

# strugling with a nested formula

I am trying to create an auto error message to flag up an incomplete entry. The formula I've written seems logical to me but  Excel wont accept it and gives me an error message.

=IF(OR(Part1!B5>0,Part1!J19>0,Part1!B6>0)),IF(AND(Part1!B5>0,Part1!J19>0,Part1!B6>0)),Part1!B5,"ERROR"," "

if anyone could point out my error id be grateful.

5 Replies
Highlighted
Solution

# Re: strugling with a nested formula

Nested IF looks like

`=IF(Cond1, IF(Cond2, A, B), C)`

`=IF(Cond1), IF(Cond2), A, B, C`

Other words, that's not a formula at all.

Highlighted

# Re: strugling with a nested formula

Perhaps, this formula returns your desired result:
=IF(AND(Part1!B5>0,Part1!B6>0,Part1!J19>0),
Part1!B5,
"ERROR")
Highlighted

# Re: strugling with a nested formula

As I understood the logic is

```if <at least one entered> then
if <all entered> then B5
else "ERROR"
else <empty string>```

which is directly translated into nested IF

Highlighted

# Re: strugling with a nested formula

Thanks Sergei I re wrote it as you said and its working

=IF(OR(Part1!B5>0,Part1!J19>0,Part1!B6>0),IF(AND(Part1!B5>0,Part1!J19>0,Part1!B6>0),Part1!B5,"ERROR")," ")

I'll try to remember to this in future

Highlighted

# Re: strugling with a nested formula

You are welcome, glad to help. In general it's always better to start not from formula but from formulating the logic in plain language. If only you didn't do the similar few dozens of times.