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)