$10

I've got data like this below. All the weights are supposed to be consistent. So for example all 3 pound weights are supposed to be $5, regardless of province. But there could be an error somewhere, such as in the last line. Is there a way to simply find all the difference prices for each...

Hello, I'm wondering if there is a weigh to "weight" my y axis on an excel chart. I have many points that fall in between $0 and $1,000,000, fewer that fall between $1,000,001 and $10,000,000 and very few greater than $10,000,000. So, I would like the points that fall in between $0 and...

I have a project due at work in 2 hours so I'm hoping I can get some help before that! I have a huge set of data with some blanks. See example below: <tbody> Order # Shipping Cost Our Charge Province Weight Class 100 $20 $10 ON 0-5 101 $10 BC 0-5 102 $30 $10 PQ 5-10...

I have read many posts similar to this but can't get my vba code to work. Please help. Sample data: <tbody> A1 A2 A3 A4 A5 A6A7 </tbody> <colgroup><col><col><col><col><col><col><col></colgroup><tbody> 21609 Gold $10 Person1 1 $10 Raffle1 21609 Gold $10 Person2 9 $90 Raffle1 21609...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Calibri; color: #000000}</style>I'm trying to calculate the cumulative total up to a certain maximum. In the example below, I need column D to calculate the contribution amount (by multiplying Column B and Column C), but...

Hi all, I'm new to Excel and totally overwhelmed trying to master it. In my spreadsheet that will keep track of my stock investments, I want Column H (total profit) to subtract $10 from every answer to factor in commission fees. My formula for Column H is: =(E3-D3)*F3-10, where E3 is my sale...

Hello, I am trying to get automated text (highlighted in color red) based on the selected range and need solution in cells which says Total (Apr-Dec) and Total (Feb-Nov). This label should be based on corresponding month where 1st value in counter row is 1 and corresponding month where last...

How can I calculate the monthly payment required to save for an item with a current cost of $10,000 rising at 5% @ year with 1.5% inflation and receiving 10% on the saved funds?

Hello! I need to be able to add a gradient if one fee is 10% higher to 30% higher than the base cost or 10% lower to 30% lower than the base cost. Example: I have a base cost of $15. Different comparison costs are $10 and $20. I need to be able to add a gradient color depending on the...

at least for me, probably not for most of you. Pricing of widgets will be volume based 1-24 $5 24-50 - $10 51-100 - $150 But not only that it will be based on term of commitment so one year pricing would be 1-24 if 1 year = $25 1-24 if 2 year = $10 1-24 if 3 year = $5 Can you give me some...

i have a 100 transactions - 50 with a debit and 50 with a credit amount in 2 separate columns, i want to identify where each of the amounts land up in the following categories - <tbody> $0 - $2,500 $2,500 - $10,000 $10,000 - $50,000 $50,000 - $100,000 $100,000 - $250,000 $250,000 -...

Hello. New here. Requesting help on the following task. I need to add a value to the number in column D based on the value of column A. For example... Before the VBA based on column A value, so if column A is like Q10, it will add $10 and if column A if like anything else, it will add $20. I've...

Hello. I want to count the number of consecutive wins in a table. Below I have an example. <tbody> $40 -$20 $25 $10 $5 $41 $32 -$5 $9 -$12 </tbody> My goal is to be able to count how many consecutive wins I was able to get. The example shows 4 consecutive wins <tbody>...

Accumulated Capital Age 6% Growth 11% Growth 18 $10,000.00 $10,000.00 28 $17,908.00 $28,394.00 38 $32,071.00 $80,623.00 48 $57,435.00 $228,923.00 58 $102,857.00 $650,009.00 The Growth amount...

Accumulated Capital Age 6% Growth 11% Growth 18 $10,000.00 $10,000.00 28 $17,908.00 $28,394.00 38 $32,071.00 $80,623.00 48 $57,435.00 $228,923.00 58 $102,857.00 $650,009.00 The Growth amount...

Morning all, I have a matrix of data that I want to turn into a database type listing so I can use pivot tables on the data. By way of example, I have a table that looks something like this: <tbody> WBS ABC WBS XYZ WBS LMN GL Code XYZ $10,000 GL Code ABC $12,000 $10,000 GL Code...