ConcatenatingTwo Formulas

[BobA]

This formula works:

if(I57>0,if(D59=I57,"p"),if(I57<0,if(D59=abs(I57),"p")

This formula also works:

if(I57<0,if(D59>abs(I57),"w","l"),if(I57>0,if(I57</d59,"l","w")))))))
</d59,"l","w")]
</d59,"l","w")

 

[BobA]

I don't think this showed up right.

 

[BobA]

I'll try again:

This formula works:

if(I57>0,if(D59=I57,"p"),if(I57<0,if(D59=abs(I57),"p")

This formula also works:

if(I57<0,if(D59>abs(I57),"w","l"),if(I57>0,if(I57< D59,"l","w")


But when I try to combine the two formulas into one I get a false reading for the last part of the formula. [if(I57>0,if(I57< D59,"l","w")]

if(D57="","",if(I57>0,if(D59=I57,"p"),if(I57<0,if(D59=abs(I57),"p"),if(I57<0,if(D59>abs(I57),"w","l"),if(I57>0,if(I57< D59,"l","w")))))))

Any help would be appreciated on how to combine these two formulas into one working formula.

 

[steve the fish]

Put spaces around the < sign before you post reply.

 

[BobA]

When I try to post the question and formulas it cuts everything off.

 

[Peter_SSs]

When I try to post the question and formulas it cuts everything off.

I have fixed it for you. See post 4 for how you can do it (though you really only need a space after a < sign and even then only if the next character is a letter).

 

[BobA]

OK, I see someone fixed my post. Thank you.

 

[BobA]

I doubt anyone could have helped me without a reference to what I am doing, but I solved it by shortening the original formula from this:

=if(I57 > 0,if(D59=I57,"p"),if(I57 < 0,if(D59=abs(I57),"p"),if(I57 < 0,if(D59>abs(I57),"w","l"),if(I57 > 0,if(I57 < D59,"l","w")))))))

To this:

=if(abs(I57)=D59,"p",if(I57 < 0,if(D59 > abs(I57),"w","l"),if(I57 > 0,if(I57 < D59,"l","w"))))))


It's just football scores. The formula tells me whether I won or lost vis-a-vis the spread and final score. However, I forgot to account for pushes, and now it works for pushes as well.

 

[Joe4]

Here is an explanation (and work around) for the posting issue you were having: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html