+ Reply to Thread
Results 1 to 3 of 3

adding to existing formula

  1. #1
    Registered User
    Join Date
    06-01-2015
    Location
    Cardiff
    MS-Off Ver
    2013
    Posts
    4

    adding to existing formula

    Hi!

    i have an existing formula and wanted to add to it but have trouble with "too many arguments"

    in cell "F4" you can choose what level of program you started on and in cell "H4" its the start date. so i want to the formula to change your end date in "I4" to coincide with your program level (higher the program, the longer your enrolled on it)

    so far i have (which works)
    =IF(F4=2,(H4+366),IF(F4=3,(H4+456)))

    but i want to add on these rules
    IF(F4=4,(H4+546))
    IF(F4=5,(H4+546))

    any help would really be appreciated!

    Thanks

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: adding to existing formula

    Hello
    I would create a lookup table with your levels and plus values. For example:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    That would find the matching Level value and add it to the start date. You can then add or adjust the levels easily rather than having them hard-coded.

    DBY

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,810

    Re: adding to existing formula

    =IF(F4=2,H4+366,IF(F4=3,H4+456,if(or(f4=4,f4=5),h4+546,""))) might be another way.
    Glenn



+ 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. Adding to an existing formula !!!!!!!!!
    By hlb129 in forum Excel General
    Replies: 3
    Last Post: 02-10-2015, 08:02 AM
  2. Adding another formula to an existing one
    By JakeMann in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2014, 08:22 AM
  3. Adding to an Existing Formula
    By jcl6543 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2014, 12:58 AM
  4. adding to existing formula
    By wwoody in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2013, 03:25 AM
  5. Adding to 2 existing formula
    By cmackay1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2012, 05:14 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