I am trying to input a formula that if a value states this much in Cell "A", then Cell "B" displays this value.
For example, in the below screen shot, if the value in Column A is 8.06 or higher/larger, Column B displays 0.5.
If Column A displays 8.05 or lower, then Column B displays 0.
@Josh_Rabener , that could be
and drag it down
You can also use IF(A1>8.05,0.5,0) in cell B1 then copy it down.
If collect functions that could be
Perhaps something else