Nested If Function - What's wrong?

[dccat33]

Can someone please tell me what's wrong with the format of the following nested if function:

=J6+L7+N7-O7-R7-S7-IF(U6=0&U7=0,0,IF(U6>=0&U7<=0,-(U6-U7),IF(U6<=0&U7>=0,U6-U7,IF(U6<0&U7<0&U6<U7,-(U6-U7),IF(U6<0&U7<0&U6>U7,U6-U7,IF(U6>0&U7>0&U6>U7,-(U6-U7),IF(U6>0&U7>0&U6<U7,U6-U7)))))))

Thanks!

 

[travis.m.roberts]

I'm no expert but I think your problem is the way you are using the & in your IF statement. I think you have to go something like IF(AND(x, y),...)

 

[Jonmo1]

welcome to the board...

Here's what's TECHNICALLY wrong with it...
Each IF can only read 1 criteria
U6>=0&U7<=0
That's 2 criteria 1. U6 > =0&U7 2. 0&U7 < =0

That explains the error messages when you try to enter the formula...


Now, what's really wrong with it, hard to say.
Hard to make sense of what 0&U7 means...

When you use & to combine to #s together, the resulting value is TEXT not a Number. So comparing that using an = or < or > operator won't work, because it's TEXT, not a nubmer..


Can you explain in words what you are trying to accomplish? There is probably a much better way..

 

[lenze]

Probably not all you need because I also got lost in your syntax, but I think this should get you started

=SUM(J6,L7,N7)-SUM(O7,R7,S7)-ABS(U6-U7)

lenze