How to change value to 0 with multiple conditions

[kauser]

Hello, 

How can i change values to 0 with multiple conditions. i know we can use either Multi Field or Multi Row but not sure how 

current output - 

Company	Serial	2024	2025	2026	2027	2028	2029	2030
ABC	123-00-89	8642	10370	12444	14933	17920	21504	25805
DEF	456-56-75	12963	15556	18667	22400	26880	32256	38707
GHI	789-21-90	19445	23333	28000	33600	40320	48384	58061
EGT	321-75-45	29167	35000	42000	50400	60480	72576	87091
DGT	345-51-24	43750	52500	63000	75600	90720	108864	130637
WSR	678-32-09	65625	78750	94500	113400	136080	163296	195956
DGT	845-10-09	98438	118125	141750	170100	204121	244945	293934

expected output - if company is DEF & Serial#456-56-75, company is DGT & Serial#345-51-24 & company is WSR and Serial#678-32-09 then balances for all year should be 0. 

Company	Serial	2024	2025	2026	2027	2028	2029	2030
ABC	123-00-89	8642	10370	12444	14933	17920	21504	25805
DEF	456-56-75
GHI	789-21-90	19445	23333	28000	33600	40320	48384	58061
EGT	321-75-45	29167	35000	42000	50400	60480	72576	87091
DGT	345-51-24
WSR	678-32-09
DGT	845-10-09	98438	118125	141750	170100	204121	244945	293934

[griffinwelsh]

@kauser use this formula in the multi field formula tool:

if [Company ] = "DEF" AND [Serial ] = "456-56-75" then 0
elseif [Company ] = "DGT" AND [Serial ] = "345-51-24" then 0
elseif [Company ] = "WSR" AND [Serial ] = "678-32-09" then 0
else [_CurrentField_]
endif

[kauser · Accepted solution]

@griffinwelsh 

Thanks for your response but its Multi -field formula not Multi Row formula