+ Reply to Thread
Results 1 to 5 of 5

If Function

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    herts
    MS-Off Ver
    Excel 2010
    Posts
    17

    If Function

    Hi and hopefully im posting this into rigft area . been away from spreadsheets for a few years and working on various personal items to get myself back into the right though process

    currently im doing a personal work data sheet reading call volumes for myself on a dialy basis, i have it set on seperate rows. but ideally id like data on seperate rows but totals in one cell

    figured i could possible use a drop down menu and then if function to read the relevant values,,
    so what i have is

    if A1 is set to display Mon, then reads set values stated

    =IF(A4="mon",(K4+L4+M4))

    one formula works fine ..however i want this set so that it will read different parameters if a different day is chosen. i can get it in seperate cells but that defeats the object. and cant seem to work out the multriple formula for it to read all in same cell

    i tried things like this

    =IF(A4="mon",(K4+L4+M4))*or=IF(A4="Tue",(K5+L5+M5))

    but didnt work so decided to ask someone smarter . any help would be greatly appreciated

  2. #2
    Registered User
    Join Date
    04-23-2012
    Location
    herts
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: If Funcgtion help .

    forgive the typos i was on a call when i was typing this

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: If Funcgtion help .

    You can nest the IF statements...

    eg...

    =IF(A4="mon",(K4+L4+M4),IF(A4="Tue",(K5+L5+M5),"")

    you can replace the "" with more nested IFs
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  4. #4
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: If Funcgtion help .

    I don't understand what is your need

    Why don't use the formula for case multiple IF
    =IF(A4="mon",K4+L4+M4, IF(A4="Tue",K5+L5+M5, 0))

    or
    =IF(A4="mon",K4+L4+M4, IF(A4="Tue",K5+L5+M5, ""))

    Or plz elaborate
    Best regard, -)iger-/iger
    If you are pleased with a solution mark your post SOLVED.

  5. #5
    Registered User
    Join Date
    04-23-2012
    Location
    herts
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: If Funcgtion help .

    Ah. almost had it but hadnt quite finished the end part of the formula . many thanks for the help much appreciated

    the nested formula worked fine

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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