Formula Fails to Post

[Learning To Excel]

This long formula is more for fun than because it's necessary. The error is that when posting or previewing on the excel forum website all or most of it is removed. The same thing happens when the formula is placed without code tags. The error doesn't seem to occur on this forum.

This is the formula

This is the resulting preview, and what actually posts:

Here is the formula for copying

=MAX(IF(SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup1")<G2,SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup1"),0),
IF(SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup2")<G2,SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup2"),0),
IF(SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup3")<G2,SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup3"),0),
IF(SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup4")<G2,SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup4"),0),
IF(SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup5")<G2,SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup5"),0),
IF(SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup6")<G2,SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup6"),0),
IF(SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup7")<G2,SUMIFS($D$2:$D$16,$C$2:$C$16,G$1,$B$2:$B$16,"Sup7"),0))

I just saw the other post about truncating formulas with <>. I'm going to assume that's the issue here as well.

 

[mole999]

the issue is with < and >, you need to put spaces around them or not post in HTML mode as its treated as instruction for the software

 

[Peter_SSs]

Its actually normally only the < sign that is a problem and it is only when that symbol is followed immediately by a letter, not a number.
So =IF(C8<8,1,2) will post fine
but =IF(C8<F8,1,2) will get the red part cut off & that when you need a space but only a space after the < sign is needed.
Another option is while replying, click Go Advanced then look down below the reply window for an option to turn off HTML in your post.

The problem doesn't occur in this forum because if you look down to the bottom right of the page you will see that HTML is turned off in this forum.

So your problem is the "<G2"