LinkBack URL
About LinkBacks
Maybe something like thos?
=IF(cell-showing-fatal>0,0,sum(range))
However, that will remain 0 for as long as there is a Fatal value
Maybe something like thos?
=IF(cell-showing-fatal>0,0,sum(range))
However, that will remain 0 for as long as there is a Fatal value
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This formula works. Thank you very much. I wonder if you also can help if I want to reset other number (K18 to K24) to 0 if there's a fatality (J17=1)?
Thank you in advance
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.
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!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks