Attached is the spreadsheet I am working on, in the Xero Template worksheet in column Q I have created the following formula: =IF(ISBLANK(A2),"","1")
I works ok but I would rather not see the 1 if A2 is blank, unfortunately i am using the same formula in Column A2 so column Q does thing there is something there. Is there a viable substitute that would accomplish the same thing and avoid having the 1 generated across all records?
Also, in column T I have the following formula: =IF(P2="Product charges",400,501) again it works ok but I am trying to avoid having any numbers show if the fields in column P2 are blank. Column P however has a ISBLANK formula as well.