Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help Needed
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help Needed
=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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help Needed
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help Needed
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAverage Function help needed | Excel Worksheet Functions | |||
Desperate Help needed with a function. | Excel Worksheet Functions | |||
function needed | Excel Worksheet Functions | |||
IF function help needed | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |