Hoping to get a little help with a formula I am making I have used it in other columns to calculate an outcome, but for some reason when I go to decimals under 0 it give me a #N/A "No Match".
Here is my goal.
- .049 and under will be given a 0
- .05 to .99 will be given a 1
- .1 to .19 will be given a 2
- .2 and above will be given a 3
The formula pulls from three different cells then adds the given number for each up.
Here is the formula I have that I have used in other columns with success.
I should mention that I am pulling the numbers from a column that is taking the different between two numbers pulled from another sheet within the document. (I know full number inception) Cell BC3 is where I have been working.
Here is a link to the document I have been working on: https://docs.google.com/spreadsheets/d/1itmmnjydelvqw8oYnOQ6IEFCJEqrn79KerRzwpEBN6k/edit?usp=sharing