Closed Thread
Results 1 to 2 of 2

How would I write the formula?

  1. #1
    Registered User
    Join Date
    08-12-2008
    Location
    Georgia
    Posts
    10

    How would I write the formula?

    In cell a1 I place a date any date let’s say 2/10/08
    In cell a2 is a number let’s say 1000
    Cell a3 will be the answer
    Since 2/10/08 falls in the 1st quarter this quarter it does not count.
    Neither does the 2nd quarter. Starting with the 3rd quarter start calculating cell a2 by the quarter!
    By these percent points, Starting with .005 and raising another .005 each quarter till it reaches .03 percent.
    Not raising any higher till I change the .03 higher.

    Thanks for any help you can give me.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Please read the Forum Rules about thread titles, and then start a new thread with an appropriate title.

    When you do, I expect you're going to need to rewrite the question as well.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Indirect Formula Modification?
    By mycon73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2008, 05:59 AM
  2. How do I subsitute part of a formula linked to another workbook?
    By Scej12 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-03-2007, 10:10 AM
  3. write formula
    By matrixknow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2007, 07:08 AM
  4. IF/and formula
    By msbing916 in forum Excel General
    Replies: 5
    Last Post: 07-18-2007, 05:58 AM
  5. named formula VBA insert error
    By Hammer_757 in forum Excel General
    Replies: 14
    Last Post: 10-14-2006, 08:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1