Absolute references

How to use the same value in multiple formulas in Google Sheets

Store a rate or threshold in one cell, point every formula at it, and update hundreds of results at once. Here are four ways to do it and the mistakes to avoid.