Put in C1 this formula: =IF(AND(R1=500,R1<600),R1/2,R1) and copy down.

Tim


"Chey" wrote:

okay after talking with a co-worker we are streamlining it.
They will type a value in a field
then if the amount is between
0-499
500-999
1000 and over

If the amount falls between 0-499 divide the amount by 4--I know how to do
this one
500-599 then divide by 8 I don't know how to do this one. I tired and no
luck
1000 and over I can do this one also

When I typed in 550 it still came out as zero, when I changed my signs
around it didn't always work

If(B10500<999,B10/8,0)

This is what I tired.

Thanks
Cheyenne