ISNUMBER or IFERROR

[caz46]

Hello,

I have the following equation: =IF(I3=1,20,IF(I3>1,(I3-1)*15+20,IF(J3>=1,(J3*100),"")))*IF([@Paid]="Unpaid",-1,1)

When I add a new row, it returns #VALUE, my question is, do I use ISNUMBER OR IFERROR in the equation, and where should I add it?

Thanks in advance for your help.
Caz

[ArviLaanemets]

In case you want an empty cell whenever any error occurs:

=IFERROR(IF(I3=1,20,IF(I3>1,(I3-1)*15+20,IF(J3>=1,(J3*100),"")))*IF([@Paid]="Unpaid",-1,1),"")

[caz46]

That works well.

Thanks for your help.