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

In those conditions you're completely *excluding* 30 and 50. So, I'll asuume
you mean:

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

Create a 2 column table like this:

...............G..........H
3............0...........1
4.....20.02...........5
5.....30.01......6.75
6.....50.01......????

Then use this formula:

=IF(COUNT(B3),B3+LOOKUP(B3,G3:G6,H3:H6),"")

I'm assuming B3 will never be a negative number.

--
Biff
Microsoft Excel MVP


wrote in message
...
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