Hi Harvey,

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

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

--
Kind regards,

Niek Otten

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