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