10%

Hello, I'm completely new to VBA i'm trying to get a set of indicators at the first available column in every sheet that the workbook contains. the column that is used for the verification is in percentage I have tried it with the macro recorder and several other things but I can't get it...

Hi, I am attempting to use a Sumproduct Froumla to work out commission but it isn't quite working. The below is what I am attempting. <colgroup><col><col><col><col></colgroup><tbody> Profit 1000 Starters 1 Actual starters 16 16000 Commision: 3194.8...

I want to generate a random number between 1 and X (where X is a dynamic number of varying length/range) in one of three columns (obviously using RANDBETWEEN) but then controlled by a manually-driven weighting factor assigned to each column I can change at any time. So far example, if A1 is...

<colgroup><col><col span="13"></colgroup><tbody> Month 0 1 2 3 4 5 6 7 8 9 10 11 12 Sales Pattern 3% 10% 21% 25% 8% 9% 10% 5% 2% 3% 2% 1% 1% Production 287 500 532 612 751 235 535 128 91 18 0 0 0 Sales 287*3% 287*10% + 500*3% 287*21% + 500*10% + 532*3% 287*25% + 500*21% + 532*10% + 612*3%...

Hi, Is there any way to calculate percentages based on the value of a number input in a cell? for example: 0-£1000 = -10% £1001-£1500 = -15% £1501-£2000 = -20% So if I input a figure in a cell, based on the formula, it will automatically calculate the percentage range for that number (as...