Hi Team,
Can you please teach me how to add ABS in my given formula, I want ABS to convert negative to positive.
Can you please teach me how to add ABS in my given formula, I want ABS to convert negative to positive.
=IF(MATCH($D$201,$FK$1:$FV$1,0)<=MATCH($B$2,$FK$1:$FV$1,0),SUMIFS(TB!$J:$J,TB!$G:$G,$A214,TB!$F:$F,F$2)+SUMIFS(F$3:F$199,$B$3:$B$199,$A214),0) |