G
Guest
Guest
I am using the IF worksheet function. If the logical test produces a value of 0, I'd like the value_if_true to be a blank cell so I could go back later and do an Edit, GoTo, Special, Blanks and delete the rows that contain blanks. I've tried making the value_if_true to be "" and that makes the cell appear blank, but the GoTo procedure described above doesn't recognize the cell as blank. Any ideas on what value_if_true Excel would recognize as a true blank cell?