I have a work sheet that I need to check a cell to see what the value
is and if it's between 0 and 20.01 then add 1 to the value of that
cell, there are 15 amounts that I need to check. Here is a simple
sample for refrence.

Thanks

If b3 =<20.01 then add 1
If b3 20.01 and less then 30.00 then add 5
If b3 30.00 and less then 50.00 then add 6.75