# Can we simplify the if-zero condition

strong textI want to check if the formula produce 0 nor not. If the output value is NOT 0 then let it be , but if it’s 0 then change it to "" (empty string).

the formula i use in the cell without the 0 check :

``````MMULT(if(AD99:BY2907<>"",AD99:BY2907, sequence(rows(AD99:AD),columns(AD99:99),0,0)), SEQUENCE(COLUMNS(AD99:99))^0)
``````

if i want to check for 0 :

``````if(
``````ifna(MMULT(if(AD99:BY2907<>"",AD99:BY2907, sequence(rows(AD99:AD),columns(AD99:99),0,0)), SEQUENCE(COLUMNS(AD99:99))^0)) , "")