Hi everyone!

I am having a hard time with some formulas due type of cells and blank cells. Hope you can help me.

This is the Nested IF I wrote:

IF( Cuota=PagoEnero, “Pagado”,IF(PagoEnero=BLANK(),“No” , IF(PagoEnero=0,Cuota-PagoEnero ,IF(Cuota-PagoEnero>0, Cuota-PagoEnero))))

The formula returns the same result if the cell is blank or is =0.

I think this is because the statement will always be true in the second one but i dont know how to fix it

My second issue is that, I do the same formula multiple times (Enero, Febrero…) and i need to summarize only the results that returns a number (not text) and make a sum

For example: Enero=0, Febrero=No, Marzo= , … Returns: Enero

CONCATENATE(IF(Enero=BLANK(), “”, IF(Enero=0, “Enero”, IF(Enero>0, “Pagado”))),IF(Febrero>0,"",“Febrero”)…and so on)

I think due the column “Enero” is a formula does not recognize the result as a number, this is not working. I have tried to change text to number and it fixed but brings other problems.

Could anyone give me some advice?

Thank you so much for your answers