Disclaimer: There are cases when hard-coding values in formulas can be more appropriate. For example, you might hard-code a weekly total to be divided by seven to generate a daily total, since the ...