Lyrics & Knowledge Personal Pages Record Shop Auction Links Radio & Media Kids Membership Help
The Mudcat Cafesj



User Name Thread Name Subject Posted
Mr Red Excel spreadsheets (16) RE: Excel spreadsheets 12 Jan 17


I sometimes allow cells to show error because formatting the cell to show nothing when processing an error may not show there is no formula. Which means you can forget how far the formulae go down. And blithly extend the data set past the row that ends the formulae.

Using a visible character instead of blank does complicate the formula, which is harder to debug as you change the data they are handling - eg numeric/non-numeric. In essence you can forget the original thinking/purpose of cells.

Keep it simple.


Post to this Thread -

Back to the Main Forum Page

By clicking on the User Name, you will requery the forum for that user. You will see everything that he or she has posted with that Mudcat name.

By clicking on the Thread Name, you will be sent to the Forum on that thread as if you selected it from the main Mudcat Forum page.

By clicking on the Subject, you will also go to the thread as if you selected it from the original Forum page, but also go directly to that particular message.

By clicking on the Date (Posted), you will dig out every message posted that day.

Try it all, you will see.