Forum Discussion

Josh_Rabener's avatar
Josh_Rabener
Copper Contributor
Mar 25, 2019

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

Good Evening,   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...
excel
Formulas and Functions
office 365
training
EGS_45's avatar
EGS_45
Copper Contributor
Mar 26, 2019

Josh_Rabener 

 

You can also use IF(A1>8.05,0.5,0) in cell B1 then copy it down. 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 26, 2019

    If collect functions that could be

    =LOOKUP(A1,{0,8.05})

    Perhaps something else

     

Resources