L
Legacy 5596
Guest
Sometimes I just can't wrap my mind around a long IF/conditional formula, like this one:
=if(sum(m2:m19>0, "NE ", if(sum(n2:n19>0, "NW ", if(sum(o219>0, "SE ", if(sum(p219>0, "SW ", if(sum(q2:q19>0, "MW ", if(sum(r2:r19>0, "CAN ", if(sum(s2:s19>0, "MX", "")
Its obviously a problem with where to put the closing parens but the help doesn't really help :wink: if just says the problem is at the point I indicate with red bolded text.
help?
=if(sum(m2:m19>0, "NE ", if(sum(n2:n19>0, "NW ", if(sum(o219>0, "SE ", if(sum(p219>0, "SW ", if(sum(q2:q19>0, "MW ", if(sum(r2:r19>0, "CAN ", if(sum(s2:s19>0, "MX", "")
Its obviously a problem with where to put the closing parens but the help doesn't really help :wink: if just says the problem is at the point I indicate with red bolded text.
help?