+ Reply to Thread
Results 1 to 5 of 5

Help--Explain Function?

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Help--Explain Function?

    Hi, first time here. I have used Excel years ago, but need to refresh skills.

    I was wondering if someone could explain this particular function to me:

    =IF(E9<>"",$D9,"")

    I know the IF is the type of function, E9 [a name] is a column-row, <> means not equal to, $ means can't(?)change, and the D9 [a per amount]is a column-row. And I believe the sets of quotes refers to something about text, but what the text is and what does it do? The formula itself is in F9 [an amount]

    This is in a Chore Payment Schedule I found somewhere that automatically totals up chore allowances for each child and want to change it to my needs, but not sure of how this formula works here and how I might need to change it some for my chart. (yeah, yeah, yeah, I know....my age....and, yes, I've still got kids in school! And still trying to get them to do chores!)

    I attached pics of the charts, but not sure if you can read them.
    Any help would be appreciated!

    Here is the Chore Payment Schedule I found:
    Chore Payment Schedule _.jpg

    And this is the same chart but shows the functions. I cut out some of the columns (they are all the same) so you can see the Total column with the names. I don't understand the formulas in Row5: =UPPER(TEXT(StartDate,"aaa")) and in Row6: =StartDate , but I believe these are the 'texts' being used in the function I'm inquiring about, just don't know what it is or how it works?
    Chore Payment Schedule_ Formulas_ .jpg

    And this is MY tentative Chore Allowance Chart:
    My Chore ChartExcel _.jpg

    I want to put Initials (Of who did the chore) in the columns of what was done (C) on what days (D thru J) and have it total up in that persons Total column (K) at the far right. So what functions do I need to use?
    Note: I know you noticed that I listed myself in the Totals column as MOM. And you ARE wondering, aren't you? Well, I just thought I would see how much I could earn doing the chores myself (which is what usually happens). Shouldn't I get paid if I do them? Yeah, baby! Maybe I'll be able to afford to take a vacation next year!

    It feels like these should be basic functions, but, you know, old age....with kids still in school....growing older by the minute....the dementia's taking over! Why, I can hardly remember who my kids are......hehehehehe! More money for me!

    Anyway, thanks so much for any help!!
    Chessie

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Help--Explain Function?

    =IF(E9<>"",$D9,"") means if e9 is not(doesn't=) blank then return what's in d9 else return blank
    ""is a way of showing blank
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,461

    Re: Help--Explain Function?

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


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


    E9 is a cell reference. Column E, Row 9.

    $D9 is a cell reference. Column D, Row 9. The $ signifies that the column reference is absolute; that is, it will not auto-adjust if the formula is dragged across the worksheet.

    <> is a comparison; it means "not equal" ... as opposed to = (equals), >= (greater than or equal), > (greater than), <= (less than or equal to) and < (less than).

    "" represents a null string, that is, the cell is empty, has no text, no value, no formula or a formula evaluates to an empty string.

    So,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    means, if cell E9 is NOT empty, set the cell containing this formula equal to the value of cell D9 (True condition), otherwise set it to a null string (False condition).


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,732

    Re: Help--Explain Function?

    Well, I THINK you were asking what that formula does. First of all "" indicates an empty string of text, so the formula is saying IF the cell E9 is not empty (or blank) then return the value which is in cell D9, otherwise return a blank to the cell that the formula is in (i.e. F9). With the dollar symbol in front of the D, then when the formula is copied across the row, it will become:

    (in G9): =IF(F9<>"",$D9,"")
    (in H9): =IF(G9<>"",$D9,"")
    (in I9): =IF(H9<>"",$D9,"")

    So, if the cell to the left of the cell_which_contains_the_formula is blank, then show a blank, otherwise show what is in cell D9.

    Hope this helps.

    Pete

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Help--Explain Function?

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. explain the FuzzyLookup function
    By cjGod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2008, 09:52 PM
  2. [SOLVED] Please explain function/formula
    By Tara H in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2006, 02:20 PM
  3. can someone explain function 'ara'?
    By feachmarsin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 08:30 PM
  4. Explain Function problem
    By martin23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2005, 07:17 AM
  5. [SOLVED] Function behaviour, can someone explain please?
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2005, 12:06 PM

Tags for this Thread

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