If Cell A contains this, then Cell B will display this

Question

Good Evening,&nbsp;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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

sergeibaklan · Answer

Josh_Rabener , that could be
=0.5*(A1&gt;8.05)
and drag it down

egs_45 · Answer

Josh_Rabener&nbsp;&nbsp;You can also use IF(A1&gt;8.05,0.5,0) in cell B1 then copy it down.&nbsp;

sergeibaklan · Answer

If collect functions that could be
=LOOKUP(A1,{0,8.05})
Perhaps something else
&nbsp;

Forum Discussion

If Cell A contains this, then Cell B will display this

3 Replies

Resources