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