Hello,
I have a sheet in which I have two columns that I want to supress zeros on. I know the if statement to use to do that, but my second if statement references the cell/column the first if statement is in, and is giving my a #VALUE! error. How can I suppress the zeros in both columns as applicable?
I've attached what I'm referring to. Sample.xlsx
- Column A is manual imput
- Column B will only have a value if there is something entered in column A. The formula in Column B is =A2*75 which is then copied down through the sheet.
- Column C is manual imput
- Column D is = B2+C2 which is then copied down through the sheet.
I want to suppress the zeros in B and D so the sheet looks cleaner and so that the user doesn't have to keep copying the formulas when they enter a new line of data.
Please assist.
Bookmarks