if i do that, the formula still works (i still get the right amount if i put something in D20, but when D20 is empty, then E20 reads #NAME?
if i change it from =if(D20>0,(D20-A21-A22-A23-A24-A25-A26-A27-A28-A29-A30-A31),””) to =if(D20>0,(D20-A21-A22-A23-A24-A25-A26-A27-A28-A29-A30-A31),)) (which is replacing the "") at the end with )) it becomes #FALSE but it will still work
so it still puts something in there, rather then a - sign or nothing