multiplier

Hello, I'm looking for a formula that will multiply a value based on the time codes of Regular (no multiplier), Overtime (1.5 multiplier) and Premium(2 multiplier). The download from our accounting software displays as follows: <colgroup><col><col></colgroup><tbody> Type Hours...

I need help writing a formula that will increase a cell by a certain multiplier if and when another cell gets beyond a certain number(s). For example: Cell G5 has a multiplier of 25. Cell B5 is where I input my number anywhere from 0-1000. Cell C5 is the output of my multiples of 25 IF the...

I've got a spreadsheet with nearly a million rows, I've included a snippet below. Each SKU should have the same cost regardless of warehouse. Also, each SKU should have the same cost multiplier regardless of warehouse. I need to find SKU's which do not abide by this. So, SKU 1343qq1 should be...

I have had a hard time finding a site that explained the construction of a regular expression. But they all seem to copy each other and leave "Capture Group" vague. So this is a possible string from which I want to extract the words. I will type the tabs as (tab) so you know where they are. I...

Good afternoon! Currently I pull a huge text file from the AS400 monthly and dump it in my project workbook, then format it. I now need to be able to modify the cost field by in VBA using a multiplier. Currently the AS400 file comes in with 63,289 rows. I run a macro to delete all page...

Hello, Hope you are well. I'm getting ok at this VBA stuff. But not that good. So I have some code here that is designed to insert column next to a column that will always have the header, "MSRP". If it returns finds a column with the header, "MSRP", what I want it to do is return the MAP...

Please see ref table below which has a multiplier per percentage range, which means that based on what range your percentage falls in, it should return the multiplier however it should also add 0.01 increments for every percentage difference. <colgroup><col span="3"><col></colgroup><tbody>...

I have a cell where I am trying to determine a multiplier from 0 to 1 in column A to then be used to scale a value in column B that produces another value in column C. However if column C is greater than zero the multiplier must be reduced until column C is zero (i.e if column C is zero I want...

I'm looking for a way to take a list of dates & times, in one column, and repeat that value by the number in another column. For example, I would like to take the Date & Time in B2 (09/02/2014 3:00:00 PM) and list it 6 times as seen in A2. In the end I will have a list much longer then I...

Hi, I am trying to create a formula such that for every increase in load by 2000kg, the multiplier would increase by 1. For example, I have a product that weighs 900kg each but the truck that the product needs to be loaded on has a maximum capacity of 2000kg. So if I need to transport 3...

I have a worksheet where data from airflows are entered. There are times we need to multiply a reading by 10 or 15 percent for Back Pressure Compensation (BPC). Other than doing this in my head, manually, I'm not sure how to accomplish it so that it still looks pretty for the client's end...

Hi all, I'm new to the forum and I'm thankful for it as it is a great source of knowledge. Here's my dilemma: I am in need of a formula that will figure out a multiplier number from a range of numbers. Here's the example I'm working with. This will be used in a worksheet to measure...