000

Hello, I am trying to create a rule for capitalizing the correct value of IT assets for accurate accounting and depreciation purposes. Here are the conditions: IF the asset and is a composite asset meaning built from multiple pieces AND/OR: <tbody> Hardware less than $5,000 INCLUDE VALUE...

<tbody> Start Date End Date Project Value Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jun-18 Dec-18 $42,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 </tbody> I have a spreadsheet that lists end dates & start dates, project values & the months of Jun 2018 - Oct 2019. What I'm...

Hello, I have the data below and can't figure out how to get an accurate annualized rate of return. 6.3% is too low. There wasn't a large initial investment but rather some smaller ones... $6,000, then $1,300, then $700, etc. as you can see from the first positive inflows. Any suggestions...

I am trying to write an excel formula to find the percentage amount from a gross amount where they's a band of different percentages. Find examples below of what I'm looking for: Bracket Group Percentage Bracket 1 0 - 8,555.50 0% Bracket 2 8,555.51 - 10,000 15% Bracket 3 10,000 - 83,333 20%...

I wish do a formula to calculate the percentage with these conditions stated below: 0 - 8,555.5 = 0% 8,555.51 - 10,000 = 15% 10,000 - 83,333 = 20% >83,333 = 30%

I have a spreadsheet that is calculating a price per square foot of a building. The cell is formatted to Accounting with 2 decimal points. This is what is should be based on my calculator tape 52,000 sf x $61.68 = $3,207,360 This is what the cell multiplication tells me 52,000 x $61.68 =...

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 -...

I've seen various q+a around this topic but can't get any of the suggested answers to work. I need help crafting a formula to find the number of unique companies that are both Special per column B and have an Investment Date in column C. I'm able to calculate the total of 5 Special companies...

How do I write a formula for the yellow box that will return a category in column D from the spend value. <colgroup><col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"...

Hello, I want to see the result of %45 for the column A numbers base on their value. If the value negative the result will shown as positive If the value is positive the result will shown as negative <colgroup><col><col></colgroup><tbody> -10,000 4,500 </tbody>...

I am trying to write a nested IF AND Function to produce a result off of a Tiered Fee Table. A . B . C . D 1 . Condition 1 Condition 2 Result if True . Result if False 2 . 1,000 2,000 1.7% ...

I need to identify transaction amounts in 2 different columns as shown below, either debit or credit will have an amount. I need to identify how many transactions are below $5000, $25000, $50000, 100,000 & 200,000, so any help would be appreciated <tbody> DebitAmount CreditAmount...

<colgroup><col><col><col><col><col></colgroup><tbody> -2,000 / -5,000 = 100 -5,000 / -10,000 = 150 -10,000 / -20,000 = 250 -20,000 and above = 500 </tbody> Hello what can be the formula to show those results between the numbers? Thanks

I want to write a formula and function which includes text and date as a desired result shown below in bold Desired Result Total Expenditures as of December 31, 2017 $100,000 The expenditures are keyed in a different sheet Monthly Expenditures Column A...

I want to write a formula and function which includes text and date as a desired result shown below in bold Desired Result Total Expenditures as of December 31, 2017 $100,000 The expenditures are keyed in a different sheet Monthly Expenditures Column A...

I need to count the number of roles where either Capital or Expense > 0 (so if Cap+Exp > 0 then count it) I am having difficulty with the equation portion <colgroup><col><col span="2"><col span="3"></colgroup><tbody> A B C 1 Role Capital Expense 2 PM $ 4,500 $ 2,500...

Hello there, I need some help on Excel. I have a large range of data, with columns with certain filters, including dates, numerical amounts and action being taken. The spreadsheet itself does it's job, whenever we need a specific part of data, such as data from a specific month, and the...

Hi all, I've got a table that I'm referring to for a tiered pricing formula. I've read through as many threads as I can count but can't seem to find the answer to my issue. My formula is always a thousand off my manual calculation. My formula is - =SUMPRODUCT(--(J2>C2:C6), J2-C2:C6, E2:E6) J2...

Are there formulas that are considered outdated/antiquated/old that would cause a file to crash or get extremely bogged down when it recalculates? Specifically, I'm being told that VLOOKUPs and ISERROR(MATCH) are old and modern versions of Excel don't handle them well. My file has about 38,000...

So, I posted a few days ago, but had an invalid explanation of what I was looking for. Apologies to the community. Here is a what I was looking for. I have these group of cells: (See Below). My problem is, if for example, I input, on another cell, pickup weight forecasted at 52,000, and...