Results 1 to 9 of 9

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

Threaded View

  1. 01-11-2022, 12:54 AM #1
    Sorachi
    Sorachi is offline
    Registered User
    Join Date
    08-20-2019
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    14

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

    Hello everyone,

    Is it possible if I want to automatically reset the final score (K26 is the sum from the numbers above) to 0 if there's a fatality case (J17=1)? I'm thinking about using IFERROR but I don't think that will work. Thank you in advance
    K26.png
    Attached Files Attached Files
    Last edited by Sorachi; 01-12-2022 at 02:25 AM.
    Reply With QuoteRegister To Reply
« 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