+ Reply to Thread
Results 1 to 9 of 9

Is it possible to automatically reset the final score to zero if a condition is met??

Hybrid View

  1. 01-11-2022, 05:14 AM #1
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,743

    Re: Is it possible to automatically reset the final score to zero if a condition is met??

    K18:K24 are not shown in your file but iif you mean resetting K4:K12 you will need VBA.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  2. 01-11-2022, 05:40 AM #2
    Sorachi
    Sorachi is offline
    Registered User
    Join Date
    08-20-2019
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    14

    Re: Is it possible to automatically reset the final score to zero if a condition is met??

    Would you please elaborate more about K18:K24 are not shown in my file? I'm sure the hidden option is off.
    I want K18:K24 to automatically scored 0 if J17=1 (or if there's a fatality case). I tried to use IFS formula but I'm not sure if it's right.
    Last edited by AliGW; 01-11-2022 at 05:41 AM. Reason: PLEASE don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  3. 01-11-2022, 06:33 AM #3
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,743

    Re: Is it possible to automatically reset the final score to zero if a condition is met??

    There is no data in K18:K24: your data starts in row 1 not row 14 as your picture!

    possible solution

    =IF(SUM($J$4:J14),0,IF(J4=G4,H4,(-100*J4)))
    Last edited by JohnTopley; 01-11-2022 at 06:37 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Scoring spreadsheet that needs to reset to zero if score goes negative
    By RickstaNZ in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-01-2019, 11:20 PM
  2. Formula to increase number based on WINS/LOSSES or FINAL SCORE
    By tivory in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2016, 07:31 PM
  3. IF Condition statement for Final Status
    By Rushendra in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2016, 04:50 AM
  4. Formula to calculate consective weeks w/same score, reset counter when streak is broken
    By HollyBear85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2014, 05:45 PM
  5. Unable to sort testing process final scores. decending from high score down.
    By makiah in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-10-2013, 02:19 AM
  6. [SOLVED] Trouble with tabulating final score(Selection done by radio buttons)
    By Thenesh in forum Excel General
    Replies: 9
    Last Post: 05-29-2012, 03:15 AM
  7. Combination of Assessment for a final score
    By Vinod Pandey in forum Excel General
    Replies: 3
    Last Post: 01-22-2011, 11:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1