Results 1 to 3 of 3

Auto populate based on frequency

Threaded View

  1. 06-15-2014, 11:12 PM #1
    FredJoe699
    FredJoe699 is offline
    Registered User
    Join Date
    11-24-2012
    Location
    Canada BC
    MS-Off Ver
    Excel 2013
    Posts
    6

    Angry Auto populate based on frequency

    Hi,

    Attached is my worksheet.

    I am trying to auto populate columns E to P by taking the invoice amount, frequency and the start date and then applying it appropiately. So far, I have a simple IF statement.

    =IF(B2="Quarterly",A2/4,IF(B2="Monthly",A2/12,IF(B2="Annually",A2,0))

    Thoughts?

    Thanks,

    cro0sh.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto Populate cell based on auto filter selection from table in same sheet
    By missydanni in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2013, 05:03 PM
  2. Auto Populate Calendar days based on Month/Year and auto insert work based on dates/name
    By n8lenahan in forum Excel General
    Replies: 2
    Last Post: 07-31-2013, 02:00 PM
  3. auto-populate based on input
    By JessicaSam in forum Excel General
    Replies: 1
    Last Post: 06-08-2012, 01:47 PM
  4. Auto populate column based on drop list, auto populate other columns
    By wolfen in forum Excel General
    Replies: 3
    Last Post: 02-28-2012, 11:54 AM
  5. HELP! trying to auto populate one value based on another
    By mimeca in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2008, 03:04 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1