ISNUMBER or IFERROR
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
|