06-7-2016, 03:09 PM
|
#213
|
Digital Dancing!
Join Date: Feb 2006
Location: 80 billion club, NE
Age: 31
Posts: 12,980
|
Re: The FFR Summer Scratch Card Event
Quote:
Originally Posted by remedy1502
yo rushy it says I've done a card 3 task which is false
not like it really matters right now but just letting you know
|
Oh woops, thanks for pointing that out. Had an incorrect function for that cell.
EDIT: Oh man, I would like you all to behold the beautiful function that is contained within cell T9 on each of your cards :P
Code:
=IF((SUM(COUNTIF(N2:T8, ">1"), COUNTIF(N2:T8, "★")) - COUNTIF(G2:L7, "★")) <0, 0, SUM(COUNTIF(N2:T8, ">1"), COUNTIF(N2:T8, "★")) - COUNTIF(G2:L7, "★"))
Last edited by rushyrulz; 06-7-2016 at 03:24 PM..
|
|
|