One of the biggest mistakes you can make is to hard code assumptions into your formulas. Instead, if a value might change, put it in a cell and refer to it with a reference, as explained in this video.
Comments at: https://exceljet.net/tips/dont-hard-code-assumptions-into-your-formulas

Please take the opportunity to connect and share this video with your friends and family if you find it useful.