Having problem with cell formula....need assistance please

Discussion in 'iWork Forum' started by jdmartin, Dec 7, 2011.

  1. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    21,112
    Thanks Received:
    7,307
    Hmm.

    So you want a column of dates, from which you want a summary of how many fall on each day of the week (2 on Sunday, 3 on Monday, etc.). Is that right? I'm not sure how to go about that. I may look into it later, no promises, but it's getting late tonight.

    The second one shouldn't be too hard you just need to enclose your first formula in an IF statement. You select the if-expression variable and tap the cell you are testing then enter ≠0. You then tap the if-true variable and enter your formula. I chose the DATEDIF formula as the easiest way to compute a difference in years. If you need something else to happen when the if-expression is false you would enter it in the place of the if-false variable. Otherwise ignore or delete that part of the function. For the heck of it I entered the string "N/A", so that when there is no entry in field B8, N/A appears in cell E8.

    AgeToday.jpg

    By selecting a calc method of "Y" i get my results in whole years. If B8 is a birthday then E8 will be that person's age as of the current day..

    Hold in mind that using the TODAY formula like it did in cell D8 means it is always today. If you want todays date entered, and for it to remain static, you have to enter it manually.

    To save a boringly repetitive column you could simply replace the D8 address in the DATEDIF statement with the TODAY function.
     
  2. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    21,112
    Thanks Received:
    7,307
    Ok, I finally got around to trying to count the days, so to speak. I could not find a direct way of doing so. Every attempt to apply a formula instead of a condition to the COUNTIF function failed, and I had less luck with the SUMIF function.

    The best I could come up with is a two step. First you have to convert the date to weekday using either the WEEKDAY function or the DAYNAME function. After that you can use the COUNTIF function to test against the resulting column; text or numeric respectively.

    As you can see from the screen shot below I used the DAYNAME function and tested against the text string. Also created a similar setup for the months.

    B-DayCount.jpg

    If there is anything you don't understand please let me know and I will elaborate.
     
  3. Teeeeeennna

    Teeeeeennna
    Expand Collapse
    iPF Noob

    Joined:
    Jul 20, 2017
    Messages:
    2
    Thanks Received:
    0
    IMG_2453.PNG
    I need help with formula for grading.
     
  4. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    21,112
    Thanks Received:
    7,307
    IF (conditional), (if true), if false)

    The first field needs to be the entire conditional, another words it should be (AK3 <=9). The way you've entered it the conditional is just whether AK3 exists. Then you're saying the 'if true' action is <=9, a conditional that makes no sense as an action. That is proobably a syntax error. However the main syntax error is that you end up trying to use too many fileds for the IF statment. By making the conditional the second field, you push the grade result to the (if false) field, and the nested IF statement to a non-existant field.

    The first part of your forumula should look like this (within the limits that typing on the standar keyboard permts)

    IF AK3 <= 9, "C+", IF . . .
     
    • Like Like x 3
    • Agree Agree x 1
    • List
  5. Teeeeeennna

    Teeeeeennna
    Expand Collapse
    iPF Noob

    Joined:
    Jul 20, 2017
    Messages:
    2
    Thanks Received:
    0
    Thank you...
     
  6. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    21,112
    Thanks Received:
    7,307
    You're welcome.
     

Share This Page


Search tags for this page
apple numbers mac function for todays date -excel
,
countif
,
datedif now() numbers ipad
,
im having problem with charting on my ipad please help
,
indirect function numbers mac
,

ipad numbers datedif

,
iwork indirect
,
iwork numbers sheets the formula contains a syntax error
,
iwork numbers the address function use
,
weekday function