Skip navigation

Function within a function

193 Views 3 Replies Latest reply: Nov 17, 2012 5:21 PM by Jerrold Green1 RSS
Pincushion Calculating status...
Currently Being Moderated
Nov 17, 2012 9:42 AM

Hi guys, I'm really sorry for this elementary question – I did try to find out the answer by myself but I can't find it. This is the problem. I have a column of durations in seconds, and I want to know the average of those times in minutes. Why does

 

=DUR2MINUTES("AVERAGE(J4:J9)s")

 

not work? It says syntax error. I don't know what the syntax is supposed to be for using one function inside another, but =SUM(AVERAGE(J4:J9), 12) and =DUR2MINUTES("12s") both do work, so I thought I was being consistent.

 

 

I know I can just put the average of the seconds in one cell and change it into minutes in the next, but I can't imagine it can't be done directly.

Numbers, Mac OS X (10.7.5)
  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Nov 17, 2012 5:06 PM (in response to Pincushion)

    Pincushion wrote:

     

    Hi guys, I'm really sorry for this elementary question – I did try to find out the answer by myself but I can't find it. This is the problem. I have a column of durations in seconds, and I want to know the average of those times in minutes. Why does

     

    =DUR2MINUTES("AVERAGE(J4:J9)s")

     

    not work? It says syntax error. I don't know what the syntax is supposed to be for using one function inside another, but =SUM(AVERAGE(J4:J9), 12) and =DUR2MINUTES("12s") both do work, so I thought I was being consistent.

     

     

    I know I can just put the average of the seconds in one cell and change it into minutes in the next, but I can't imagine it can't be done directly.

    Hi Pin,

     

    Your problem is not with the nesting of functions, it is, as the error tells you, a syntax error. You are attempting to concatenate the average of a range of numerical values with the text character "s" and you haven't used the proper contatenation rules. A properly functioning equivalent would be:

     

    =DUR2MINUTES(AVERAGE(J4:J9)&"s")

     

    Regards,

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Nov 17, 2012 5:21 PM (in response to Pincushion)

    Thanks for the feedback.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.