How would I create an if formula with not null? Basically I have the formula below that says not = to 0. However that 0 is a null value.

{IIF(Closing_Balance.Day_5_Closing_Balance_Sum!=0,Closing_Balance.Day_5_Closing_Balance_Sum,IIF(Closing_Balance.Day_4_Closing_Balance_Sum!=0,Closing_Balance.Day_4_Closing_Balance_Sum,IIF(Closing_Balance.Day_3_Closing_Balance_Sum!=0,Closing_Balance.Day_3_Closing_Balance_Sum,IIF(Closing_Balance.Day_2_Closing_Balance_Sum!=0,Closing_Balance.Day_2_Closing_Balance_Sum,Closing_Balance.Day_1_Closing_Balance_Sum))))}