Home

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

Josh_Rabener
Occasional Visitor

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.06 or higher/larger, Column B displays 0.5.

If Column A displays 8.05 or lower, then Column B displays 0.

 

 

Excel Example.JPG

 

 

 

3 Replies

@Josh_Rabener , that could be

=0.5*(A1>8.05)

and drag it down

@Josh_Rabener 

 

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

If collect functions that could be

=LOOKUP(A1,{0,8.05})

Perhaps something else

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies