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.

=sum(IFS(AND(BB3>=0.05,BB3<=0.09),1,AND(BB3>=0.1,BB3<=0.19),2,OR(BB3>=0.2),3,OR(BB3<0.049),0)+IFS(AND(AZ3>=0.05,AZ3<=0.09),1,AND(AZ3>=0.1,AZ3<=0.19),2,OR(AZ3>=0.2),3,OR(AZ3<0.049),0)+IFS(AND(AX3>=0.05,AX3<=0.09),1,AND(AX3>=0.1,AX3<=0.19),2,OR(AX3>=0.2),3,OR(AX3<0.049),0))

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)

Here is a link to the document I have been working on: https://docs.google.com/spreadsheets/d/1itmmnjydelvqw8oYnOQ6IEFCJEqrn79KerRzwpEBN6k/edit?usp=sharing