2 Formula in One Cell

M13HSE

Hi, I'm stuck, I have a basic formula to count resolved encounters daily, but I need to be able to show 0 in a column if the End of Day Numbers column is also 0.

Encounters.PNG

AravindGP

Hi @M13HSE ,

You can use a nested IF formula to achieve this. I am not sure of where you're picking your resolved numbers from, however, here's a sample formula you can use. The formula will fetch resolved encounters if the end of day numbers is not equal to 0. If it is equal to 0, then 0 is taken as the value.

=IF([End of Day Numbers]@row<>0, COUNT([Resolved Encounters]), [End of Day Numbers]@row)