Function Help Needed

Hope someone can help me with the proper function in MS Excel (2002) to do the following.

If a number in a cell is between 50000 and 64999, that number is to be multiplied by .05 (5%). If lower or higher than this range, the result should be zero.

For example, if the sum in the cell is $57,600, the result shown in another cell should show that number times 5%.

Please help if you know the correct formula to do this. Thanks so much.

--
___________________
Harvey Gersin
hgersin@comcast.net

If your number is in B1 try:
=IF(AND(B1>=50000,B1<=649990),B1*0.05,0)

Hope this helps
Rowan

Harvey Gersin wrote:
> Hope someone can help me with the proper function in MS Excel (2002) to
> do the following.
>
> If a number in a cell is between 50000 and 64999, that number is to be
> multiplied by .05 (5%). If lower or higher than this range, the result
> should be zero.
>
> For example, if the sum in the cell is $57,600, the result shown in
> another cell should show that number times 5%.
>
> Please help if you know the correct formula to do this. Thanks so much.
>
> --
> ___________________
> Harvey Gersin
> hgersin@comcast.net <mailto:hgersin@comcast.net>

=if(or(a1>=50000,a1<=64999),a1*.05,0)

Assuming a1 is the cell you want to evaluate.

"Harvey Gersin" wrote:

> Hope someone can help me with the proper function in MS Excel (2002) to do the following.
>
> If a number in a cell is between 50000 and 64999, that number is to be multiplied by .05 (5%). If lower or higher than this range, the result should be zero.
>
> For example, if the sum in the cell is $57,600, the result shown in another cell should show that number times 5%.
>
> Please help if you know the correct formula to do this. Thanks so much.
>
> --
> ___________________
> Harvey Gersin
> hgersin@comcast

The first post is correct, you want ans AND not OR. Sorry

"Harvey Gersin" wrote:

> Hope someone can help me with the proper function in MS Excel (2002) to do the following.
>
> If a number in a cell is between 50000 and 64999, that number is to be multiplied by .05 (5%). If lower or higher than this range, the result should be zero.
>
> For example, if the sum in the cell is $57,600, the result shown in another cell should show that number times 5%.
>
> Please help if you know the correct formula to do this. Thanks so much.
>
> --
> ___________________
> Harvey Gersin
> hgersin@comcast

Hi Harvey,

=IF(AND(A1>50000,A1<65000),A1*5%,0)

make sure you have your limits and operators (<,<=, >, >=, etc) right

--
Kind regards,

Niek Otten

"Harvey Gersin" <hgersin284054MI@comcast.net> wrote in message news:34KdncXp_5wRRBHeRVn-qw@comcast.com...
Hope someone can help me with the proper function in MS Excel (2002) to do the following.

If a number in a cell is between 50000 and 64999, that number is to be multiplied by .05 (5%). If lower or higher than this range, the result should be zero.

For example, if the sum in the cell is $57,600, the result shown in another cell should show that number times 5%.

Please help if you know the correct formula to do this. Thanks so much.

--
___________________
Harvey Gersin
hgersin@comcast.net