Forum Discussion
Solved
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...
Nested IF looks like
=IF(Cond1, IF(Cond2, A, B), C)
Your formula is
=IF(Cond1), IF(Cond2), A, B, C
Other words, that's not a formula at all.
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
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.