2013年9月28日星期六

How do I sum numbers in excel with conditional formatting?

  • best mutual fund companies
  • reliance mutual fund
  • credit report three
  • green supply chain management
  • normal mode analysis
I have a random set of numbers (9 columns by 9000 rows) with conditional formatting that highlights the top 3 as GREEN and the bottom 3 as RED.

How do I sum the numbers based SOLELY on their conditional formatting color (as I may change the values)?


Additional Info:

*This is a program, for school, analyzing funds in the stock market, so the RED is shorting and the GREEN is longing the funds.

**The bottom three will need to be taken the inverse of. So if they are -1,-3,-5; then it would equal 9. But if it is like: -2, 7, -4; then it would equal -1. The top three can be summed like normal.

How do I sum numbers in excel with conditional formatting?

How to compute for copyright amortization (under IFRS and US GAAP)?

  • cost of moving
On Jan 1, 2000, XXX Co. purchased a copyright for 600,000, having an estimated useful life of 16 years. In Jan 2004, XXX paid 90,000 for legal fees in a successful defense of the copyright. What is copyright amortization for the year ended Dec 31, 2004?


(Under US GAAP, the cost of the copyright includes the cost of legal fees and other costs of successfully defending the intangible asset, whereas under IFRS, it is expensed)


Under IFRS, the answer is 37,500 but I dont get how?


Under US GAAP no answer is given, but I got 48,125. Am I correct?


Help would be greatly appreciated..
  • Additional Details
  • Here is how I got 48,125:


    Depreciation for 2000-2003

    600,000/16 x 3 = 112,500


    Deprection for 2004

    (600,000 90,000 - 112,500)/(16-4) = 48,125

  • How to compute for copyright amortization (under IFRS and US GAAP)?

    Wire transfer to My saving account SBI?

    • send money online using bank account
    • how to save money in bank account
    • financial accounting course
    I have my brother in china and he wants to send me money to my SBI saving account and i dont have PAN card


    the question is can i recieve the money to my bank account and withdraw by ATM


    the amount is 7000$

    Wire transfer to My saving account SBI?

    How do I save money on shipping from Canada to the USA?

    • auto shipping quote
    • online shipping quote
    • international bank account
    I need to send a ton of packages from Canada to the USA, about 300 boxes­. They are all going to different destinations across the country. Canada Post has rates well over double what USPS charges, so is there an alternate way of sending packages? Like shipping the lot to a border down, having them cross to the US and ship through USPS?

    How do I save money on shipping from Canada to the USA?

    How do I know if my job interview went well?

    • purchasing manager courses
    • second pregnancy differences
    I interviewed at a well known steakhouse and I made the manager smile and laugh and we talked for 20+ minutes. Afterwards he said they were for sure hiring and I had to have a second interview and then a third interview. It's been 3 days and they didn't call me for a second interview yet. The guy really seemed interested! My best friend words there and he asked her to bring in some quality people, and she suggested me. Should I call them in a few days and see what is going on? I want this job so very much but I don't wanna sound desperate.

    How do I know if my job interview went well?

    How to compute the total cash spent for inventory?

    • online accounting education
    • online cash advance loans
    How do I get the total cash spent for inventory in 2013?


    Accounts Payable

    Jan 1, 2013 -- 200, 000

    Dec 31, 2013 -- 240,000

    COGS 2013 -- 900,000

    Inventory

    Jan 1, 2013 -- 300,000

    Dec 31, 2013 -- 200,000


    I was told that the correct answer is 760,000.

    How to compute the total cash spent for inventory?

    Pay minimum or pay in full on interest free credit card?

    • credit card charge
    • credit card transfers
    • credit card names
    • wire money online with credit card
    • find credit score
    • credit report and score from all 3 bureaus
    • credit score explained
    • late payment charges
    My new credit card is interest free for 12 months, and I just got my first bill, would only paying the minimum (£25) or the full balance (£70) help my credit score/history more? I won't be charged any interest so why pay the full amount?

    Pay minimum or pay in full on interest free credit card?