Functions

Please Help Qtr Mtch
I was provided with the following formula to calculate qtrly match: =IF(DATEDIF(C2,DATE(YEAR(TODAY()),12,31),"y")<21,0,G2*MIN(D2,3%)+50%*MAX(0,MIN(G2*3%,D2*2%))). The problem is that this formula is not calculating the correct amount for anything over 4%. Match is 100% of the first 3% and 50% of the second 2%, so ... 9 Jul 2008 14:44

Formula
Dear All Im wandering if someone can assist. I have two columns each containing a Monetary Value Amount Chargeable and Potential Charge Im after an If formula to calculate in a third column the actual charge based on the following scenarios If the Amount Chargeable is greater than Potential Charge then... 3 Jul 2008 12:31

finding and replacing
HELP! I have a mind numbingly boring job of updating the prices in our work spreadsheet. Is there a way I can find a list of product codes in the new prices spreadsheet and then automatically update the specific field in the product database? ... 3 Jul 2008 08:23

Moving The Decimal Point Of Existing Entries
Hi Everyone, hoping someone can help me with this. I have a massive sheet full of numbers, however, they should have been entered as values less than 1. eg - Cell has an entry of "5" and it should be "0.05" Is there anyway I can move the decimal place in the cells I want to? Thanks for your help, Th... 3 Jul 2008 07:22

taking conditions from one spreadsheet to another
I need to take column B (customer account number) and state if the value is x then take the monetary value in column P and add up the total value of all entries for this customer. Then I want to place the answer on a different worksheet in the same work book. Please can someone help me? ... 3 Jul 2008 08:23

work book open _ event
Hi All, I want to run macors only on that files which are in csv format. Thanks Hassan ... 3 Jul 2008 08:23

Advice on a couple of things if possible.
Describing what im after is not going to be easy, please bear with me on these!! Firstly I was wondering if its possible for a cell to auto populate with a formula if other cells have data added to them. For example, say I type Bob into C3 and Smith into D3, without having to do anything manually my self can ... 4 Jul 2008 04:54

Copy Left Word
Hi I have a column that contains cells with tag numbers and description, I need to extract the tag number and place this two cells to the right, ie I need to copy the left most string within a cell. Thanks Alec ... 3 Jul 2008 11:29

sumbycolor formula
how can i enter SUMbycolor formula. It gives me error message REF! ... 3 Jul 2008 08:23

Take first word out of cell and put it in a new cell
I have a list of data and I want to remove the first word of each cell in one column and put it in a separate column. Is there a formula for this? ... 3 Jul 2008 09:25