+ Reply to Thread
Results 1 to 2 of 2

I need to edit my formula so it displays every second true result

  1. #1
    Registered User
    Join Date
    12-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    I need to edit my formula so it displays every second true result

    I am working on a cash projection spreadsheet that has the columns in a daily format. In some instances I need the expenses to repeat daily, or weekly or monthly - and I have managed to work formulas based off the days of the week or the dates that I have across rows 1, 2 & 3.

    However I am stuck on the last one - getting the results to show fortnightly.

    I am currently using an IF formula as follows
    =IF($E$2:$CTV$2=$C21,$D21,"")
    E2:CTV2 is the "days of the week" repeated over and over again
    C21 is the day of the week I need the $$ to appear ie Mon or Tue or Wed
    D21 is the $$ figure I need it to show repeatedly across the spreadsheet

    But how on earth do I get it to show every SECOND true result so that it shows an expense every fortnight (every second Thur) rather than weekly?

    Thanks in advance for any help you can provide!
    Last edited by PatAlex; 12-18-2013 at 07:18 AM.

  2. #2
    Registered User
    Join Date
    12-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: I need to edit my formula so it displays every second true result

    I have update the title.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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