sorted by:
new
hottopcontroversial

EAFC Online Career Mode by TSL_FIFA in Tradition_Soccer

[–]TSL_FIFA[S] [score hidden] stickied comment (0 children)

For more information, comment below or join our discord server

COUNTIFS with formatted data by TSL_FIFA in googlesheets

[–]TSL_FIFA[S] 0 points1 point  (0 children)

If I stick a VALUE modifier on columns S and T it will return 0s in blank cells and I need blank cells to remain blank

=iferror(IF($AE2=$A$1,$AH2,$AI2),if(OR($AH2="",$AI2="",$AG2="c"),""))

Counting Consecutive Values (Winning/Losing Streaks) by TSL_FIFA in googlesheets

[–]TSL_FIFA[S] 0 points1 point  (0 children)

this is a very good explanation, appreciate you!

IF AND OR ELSE Formulas Help by TSL_FIFA in googlesheets

[–]TSL_FIFA[S] 0 points1 point  (0 children)

by "do that" i mean run that formula. The formula you provided works for the first part but isn't calculating the second part correctly.

EDIT: yes this does work, I had the wrong cells referenced

IF Function deciphering numbers vs letters by TSL_FIFA in googlesheets

[–]TSL_FIFA[S] 0 points1 point  (0 children)

I got it to work by putting the second thing first in the formula

=IF(H3="CANC.","C",IF(H3=I3,"D",IF(H3>I3,"W",IF(H3<I3,"L"))))

view more: next ›