Brian Entz
Level 1 (5 points)
Mac OS X

Q: Once a certain number is reached in tally -drop to zero

I have a column with each row successively larger as each row contains the tally of the row above it plus a new figure. HOWEVER, once the tally comes to a certain number (found in a separate cell) I want all further rows to drop to zero. The tally maxes out once it reaches the figure in the separate cell and goes zero or blank thereafter.

Posted on Sep 5, 2016 12:07 AM

by Yellowbox,Apple recommended
Yellowbox Yellowbox
Level 6 (10,430 points)
Mac OS X
A:

Hi Brian,

Screen Shot 2016-09-05 at 11.09.16 PM.png

The Threshold value is in a separate table, but it could be anywhere in the document.

Formula in C2 of Table 1 (and Fill Down)

=IF(B2<Threshold::A$1,B2,0)

If a Raw Tally (Column B) is less than the Threshold value, then Raw Tally, else zero.

You can hide Column B.

 

Regards,

Ian.

Posted on Sep 5, 2016 6:15 AM

Close
Brian Entz

Q: Once a certain number is reached in tally -drop to zero

  • All replies
  • Helpful answers

  • by Yellowbox,Apple recommended

    Yellowbox Yellowbox Sep 5, 2016 6:15 AM in response to Brian Entz
    Level 6 (10,430 points)
    Mac OS X
    Sep 5, 2016 6:15 AM in response to Brian Entz

    Hi Brian,

    Screen Shot 2016-09-05 at 11.09.16 PM.png

    The Threshold value is in a separate table, but it could be anywhere in the document.

    Formula in C2 of Table 1 (and Fill Down)

    =IF(B2<Threshold::A$1,B2,0)

    If a Raw Tally (Column B) is less than the Threshold value, then Raw Tally, else zero.

    You can hide Column B.

     

    Regards,

    Ian.