LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harvey Gersin
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DAverage Function help needed xrayr Excel Worksheet Functions 3 July 26th 05 04:09 PM
Desperate Help needed with a function. Lori Excel Worksheet Functions 3 July 21st 05 03:19 AM
function needed David Harrison Excel Worksheet Functions 1 February 23rd 05 11:28 PM
IF function help needed jmcclain Excel Worksheet Functions 2 February 23rd 05 04:33 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"