Not sure exactly what you want but something like this perhaps...

=if(b10<500, b10/4, if(b10<600, b10/8, if(b10<1000, b10/4, 0)))
--
HTH...

Jim Thomlinson


"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

"Chey" wrote:

I tired this and it did not work twords my advantage.

Sorry

Do you know any other techniques.

"Jim Thomlinson" wrote:

Here is one method. You can do this without using macros by doing a little
bit of slight of hand... The jist of it is to hide the value that you enter
by formatting it to not show and then use the camera object to show the
results of a formula.

Assuming you are dealing with cell A1 on Sheet1... For Sheet 1 A1 make the
font colour the same as the background colour. Add the formula =Sheet1!A1/4
in cell A1 on Sheet 2. Select Tools - Options - View and uncheck Gridlines.
Now follow the oddity outlined here...

http://j-walk.com/ss/excel/odd/odd04.htm

I like this method because you do not need to enable macros and the original
value entered by the user is there in the cell (shows in the formula bar when
the cell is selected).
--
HTH...

Jim Thomlinson


"Chey" wrote:

I have a cell that when I type the number for example 12 I want it to return 3
So the Number I type in divided by 4.
I have some other cells I am going to do with the number 8 and so on.
Thanks
Cheyenne