Mar 25 2019 02:47 PM
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.
Mar 25 2019 03:05 PM
Mar 25 2019 06:10 PM - edited Mar 25 2019 06:17 PM
Mar 26 2019 01:30 AM
If collect functions that could be
=LOOKUP(A1,{0,8.05})
Perhaps something else