Wednesday, August 18, 2021

OCT2BIN - Docs Editors Help [gg-docs-en]

OCT2BIN

The OCT2BIN function converts a signed octal number to signed binary format.

Sample Usage

OCT2BIN(37,8)

OCT2BIN(A2)

Syntax

OCT2BIN(signed_octal_number, [significant_digits])

  • signed_octal_number - The signed 30-bit octal value to be converted to signed binary, provided as a string.

    • The most significant bit of signed_octal_number is the sign bit; that is, negative numbers are represented in two's complement format.

    • For this function, this value has a maximum of 777 if positive, and a minimum of 7777777000 if negative.

    • If signed_octal_number is provided as a valid octal number, it will automatically be converted to the appropriate string input. For example, OCT2BIN(177) and OCT2BIN("177") yield the same result: 1111111.

  • significant_digits - [ OPTIONAL ] The number of significant digits to ensure in the result.

    • If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches significant_digits.

    • This value is ignored if the most significant bit of signed_octal_number is 1; that is, if the expressed signed_octal_number is greater than or equal to 4000000000.

Notes

  • As with any octal value, only the digits 0-7 are valid. Digits outside of this will cause OCT2BIN to return a #NUM! error.

  • If the number of digits required is greater than the specified significant_digits, the #NUM! error is returned.

See Also

OCT2HEX: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

OCT2DEC: The OCT2DEC function converts a signed octal number to decimal format.

HEX2OCT: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

HEX2DEC: The HEX2DEC function converts a signed hexadecimal number to decimal format.

HEX2BIN: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

DEC2OCT: The DEC2OCT function converts a decimal number to signed octal format.

DEC2HEX: The DEC2HEX function converts a decimal number to signed hexadecimal format.

DEC2BIN: The DEC2BIN function converts a decimal number to signed binary format.

BIN2OCT: The BIN2OCT function converts a signed binary number to signed octal format.

BIN2HEX: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

BIN2DEC: The BIN2DEC function converts a signed binary number to decimal format.

Examples

Converts an octal number to its binary value.

DEC2OCT - Docs Editors Help [gg-docs-en]

DEC2OCT

The DEC2OCT function converts a decimal number to signed octal format.

Sample Usage

DEC2OCT("100",8)

DEC2OCT(A2)

Syntax

DEC2OCT(decimal_number, [significant_digits])

  • decimal_number - The decimal value to be converted to signed octal, provided as a string.

    • For this function, this value has a maximum of 536870911 if positive, and a minimum of -53687092 if negative.

    • If decimal_number is provided as a valid decimal number, it will automatically be converted to the appropriate string input. For example, DEC2OCT(199) and DEC2OCT("199") yield the same result: 307.

  • significant_digits - [ OPTIONAL ] The number of significant digits to ensure in the result.

    • If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches significant_digits.

    • This value is ignored if decimal_number is negative.

Notes

  • If the number of digits required is greater than the specified significant_digits, the #NUM! error is returned.

  • Ensure that any calculations using the result of DEC2OCT take into account that it is in octal. Results will be silently converted by Google Sheets; thus if cell A2 contains 111, the octal equivalent of the decimal value 73, and B2 contains a formula such as =A2+9, the result will be 120, which is incorrect in octal calculation.

See Also

OCT2HEX: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

OCT2DEC: The OCT2DEC function converts a signed octal number to decimal format.

OCT2BIN: The OCT2BIN function converts a signed octal number to signed binary format.

HEX2OCT: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

HEX2DEC: The HEX2DEC function converts a signed hexadecimal number to decimal format.

HEX2BIN: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

DEC2HEX: The DEC2HEX function converts a decimal number to signed hexadecimal format.

DEC2BIN: The DEC2BIN function converts a decimal number to signed binary format.

BIN2OCT: The BIN2OCT function converts a signed binary number to signed octal format.

BIN2HEX: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

BIN2DEC: The BIN2DEC function converts a signed binary number to decimal format.

Examples

Converts a decimal number to its octal value.

Add music to your queue to play next on your iPhone, iPad, iPod touch, or Android device - Apple Support

Add music to your queue to play next on your iPhone, iPad, iPod touch, or Android device

Play a song, then have similar songs autoplay. Or queue up music that you want to play next. Share control of your queue. And transfer your queue between your iPhone and HomePod so you can keep listening without missing a beat — all with Apple Music.

Let Autoplay pick what plays next

Autoplay takes the work out of choosing what to play next. Just play a song, then Autoplay finds similar songs and plays them afterward.

To see your Autoplay queue:

  1. Tap the song that's playing at the bottom of your screen.
  2. In the lower-right corner of your screen, tap Playing Next the Playing Next icon.
  3. Scroll down to Autoplay. 

To turn Autoplay on or off, tap the Autoplay button the Autoplay button icon in the upper-right corner of your screen. If you turn off Autoplay on one of your devices, then Autoplay is turned off on any device that's signed in with your Apple ID.

iPhone showing the Autoplay button on the Playing Next screen

Autoplay is available only if you subscribe to Apple Music.

Choose what you want to play next

  1. Open the Apple Music app and play music.
  2. Find a song, album, or playlist that you want to play next.
  3. When you find something, touch and hold it, then choose when you want it to play:
    • To play your selection right after the song that's playing, tap Play Next the Play Next icon.
    • To move your selection to the bottom of your music queue, tap Play Last the Play Last icon.

iPhone showing a song selected to play next

See and change what plays next

  1. Tap the song that's playing at the bottom of your screen.
  2. In the lower-right corner of your screen, tap Playing Next the Playing Next icon.
  3. From here, you can see and edit your Playing Next and Autoplay queues.
    • Reorder music: Drag the three lines  the Reorder icon next to a song up or down.
    • Remove a song: Swipe left over a song, then tap Remove.

iPhone showing music that's being rearranged on the Playing Next screen

If you play music that's not in your queue, you'll see an option to clear your music queue. If you choose Clear, then the music in your queue is replaced with the music you've selected to play.

Share control of a music queue on Apple TV or HomePod

If you're at a friend's house or have guests over, you can all add music to the queue on an Apple TV or HomePod. Everyone that wants to add music needs a subscription to Apple Music and an iPhone, iPad, or iPod touch.

  1. Connect your iPhone, iPad, or iPod touch to the same Wi-Fi network as the Apple TV or HomePod.
  2. On your iPhone, iPad, or iPod touch, open the Apple Music app.
  3. Tap the player at the bottom of the screen.
  4. Tap AirPlay the AirPlay icon.
  5. Scroll and tap the card for HomePod or Apple TV. Then tap the card again to return to the Apple Music app and see the music queue for that device.
  6. Find a song, album, or playlist that you want to play next, touch and hold it, then choose when you want it to play:
    • To play your selection right after the song that's playing, tap Play Next the Play Next icon.
    • To move your selection to the bottom of the music queue, tap Play Last the Play Last icon.

Transfer your music queue between iPhone and HomePod

Update your HomePod and iPhone to the latest version of iOS. Then you can transfer what you're listening to between the two devices automatically, or with just a tap.

  • To transfer what's playing on your iPhone to HomePod, bring your iPhone within 3 feet of your HomePod. Then tap the message on your iPhone that says Play on HomePod.
  • To automatically transfer what's playing back and forth between your iPhone and HomePod, just hold your iPhone close to the top of your HomePod.

HomePod isn't available in all countries and regions.

Information about products not manufactured by Apple, or independent websites not controlled or tested by Apple, is provided without recommendation or endorsement. Apple assumes no responsibility with regard to the selection, performance, or use of third-party websites or products. Apple makes no representations regarding third-party website accuracy or reliability. Contact the vendor for additional information.

Published Date: 

YEAR - Docs Editors Help [gg-docs-en]

YEAR

Returns the year specified by a given date.

Sample Usage

YEAR(DATE(1969,7,20))

YEAR(A2)

YEAR(40909)

Syntax

YEAR(date)

  • date - The date from which to calculate the year. Must be a cell reference to a cell containing a date, a function returning a date type, or a number.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE, DATEVALUE or TO_DATE, or a date serial number of the type returned by the N function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

  • YEAR does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, YEAR(10/10/2000) is interpreted as YEAR(0.005), the quotient of 10 divided by 10 divided by 2000.

See Also

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

DAY: Returns the day of the month that a specific date falls on, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the year specified by a given date.

WORKDAY - Docs Editors Help [gg-docs-en]

WORKDAY

Calculates the end date after a specified number of working days.

Sample Usage

WORKDAY(DATE(1969,7,20), 4, A1:A10)

WORKDAY(A2, 10)

WORKDAY(40909, 4, B2:B17)

WORKDAY(40909, 30, {40909,40924})

Syntax

WORKDAY(start_date, num_days, [holidays])

  • start_date - The date from which to begin counting.

  • num_days - The number of working days to advance from start_date. If negative, counts backwards.

    • If num_days is not an integer, the decimal part is truncated. That is, WORKDAY(A2,1.9) is equivalent to WORKDAY(A2,1).
  • holidays - [ OPTIONAL ] - A range or array constant containing the dates to consider holidays.
    • The values provided within an array for holidays must be date serial number values, as returned by N or date values, as returned by DATE, DATEVALUE or TO_DATE. Values specified by a range should be standard date values or date serial numbers.

Notes

  • WORKDAY does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, WORKDAY(10/10/2000,4) is interpreted as WORKDAY(0.005,4), where the provided date is the quotient of 10 divided by 10 divided by 2000.

  • WORKDAY calculates the end date after a specified number of working days. To calculate the number of working days between two dates, use NETWORKDAYS.

  • WORKDAY works similarly to WORKDAY.INTL but only treats Saturday and Sunday as the weekend. Use WORKDAY.INTL to use other days of the week as the weekend.

See Also

WORKDAY.INTL: Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

TO_DATE: Converts a provided number to a date.

NETWORKDAYS: Returns the number of net working days between two provided days.

N: Returns the argument provided as a number.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the end date after a specified number of working days.

Buy music from the iTunes Store - Apple Support

Buy music from the iTunes Store

If you don't subscribe to Apple Music or want to purchase a song or album, you can buy music from the iTunes Store. You can also download music that you purchased to your device to listen to offline.

Use the iTunes Store app on your iPhone, iPad, or iPod touch

  1. Open the iTunes Store app.
  2. At the bottom of the screen, tap Music.
  3. Find the song or album that you want to buy.
    iPhone showing an album you can buy in the iTunes Store
  4. Tap the price next to the song or album to buy it.
  5. Sign in with your Apple ID and password to complete the purchase. Need help?

To find the music that you purchased, open the Apple Music app and tap the Library tab.

To download music to listen to offline, tap the Download button the Download button icon.


Use the Apple Music app on your Mac with macOS Catalina

  1. Open the Apple Music app.
  2. Use the Search bar to find the song or album that you want to buy.
  3. Click the iTunes Store button in the upper-right corner. Don't see the iTunes Store?
    The Apple Music app on a Mac showing the iTunes Store button below the volume controls, next to the Your Library button.
  4. Click the price next to the song or album to buy it.
  5. Sign in with your Apple ID and password to complete the purchase. Need help?

After you buy music, you can find it in your music library. 

To download music to listen to offline, find the song or album in your library, then click the Download button the Download button icon.

If you don't see the iTunes Store

In the latest version of macOS, the iTunes Store might be hidden. Here's how to find it:

  1. Open the Apple Music app.
  2. In the menu bar, choose Music > Preferences.
  3. Go to the General tab and select iTunes Store.
  4. Click OK.


Use iTunes on your PC or Mac with macOS Mojave or earlier

  1. Open iTunes.
  2. Choose Music from the pop-up menu, then click Store in the navigation bar.
  3. Find the song or album that you want to buy.
  4. Click the price next to the song or album to buy it.
  5. Sign in with your Apple ID and password to complete the purchase. Need help?

After you buy music, you can find it in your music library. 

To download music to listen to offline, find the song or album in your library, then click the Download button the Download button icon.


Learn more

Published Date: 

TIME - Docs Editors Help [gg-docs-en]

TIME

Converts an hour, minute, and second into a time.

Sample Usage

TIME(11,40,59)

TIME(A2,B2,C2)

Syntax

TIME(hour, minute, second)

  • hour - The hour component of the time.

  • minute - The minute component of the time.

  • second - The second component of the time.

Notes

  • Inputs to TIME must be numbers - if a string or a reference to a cell containing a string is provided, the #VALUE! error will be returned.

  • TIME will silently recalculate numeric time values which fall outside of valid ranges. For example, TIME(25,0,0), which specifies the illegal hour 25, will create a time of 1:00 AM. Similarly, TIME(12,0,60), which specifies the illegal 61st second of a minute (:00 being the first second), will create a time of 12:01:00.

  • TIME will silently truncate decimal values input into the function, e.g. an hour of 12.75 will be interpreted as 12.

See Also

DATE: Converts a year, month, and day into a date.

Examples

Returns the time value from specified hours, minutes and seconds.

SECOND - Docs Editors Help [gg-docs-en]

SECOND

Returns the second component of a specific time, in numeric format.

Sample Usage

SECOND(TIME(11,40,59))

SECOND(A2)

SECOND(40909.0004)

SECOND("20:49:59")

 

Syntax

SECOND(time)

  • time - The time from which to calculate the second component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as TIME, or a date serial number of the type returned by the N function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

  • SECOND does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, SECOND(12:00:00) will return an error.

  • SECOND returns the intuitive understanding of seconds, and is useful primarily in other calculations rather than to extract the second component of a known time, as that value is easily known from a plain reading of the entire time.

  • Note that date objects that are created with the DATE function or by entry of a date without a time component will have a time of 0:00:00.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

TIME: Converts an hour, minute, and second into a time.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

MINUTE: Returns the minute component of a specific time, in numeric format.

HOUR: Returns the hour component of a specific time, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the second as an integer for the given time value.

MONTH - Docs Editors Help [gg-docs-en]

MONTH

Returns the month of the year a specific date falls in, in numeric format.

Sample Usage

MONTH(DATE(1969, 7, 20))

MONTH(A2)

MONTH(40909)

MONTH("7/20/1969")

Syntax

MONTH(date)

  • date - The date from which to extract the month. Must be a reference to a cell containing a date, a function returning a date type, or a number.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE, DATEVALUE or TO_DATE, or a date serial number of the type returned by the N function. Google Sheets represents dates as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

  • MONTH does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, MONTH(10/10/2000) is interpreted as MONTH(0.005), the quotient of 10 divided by 10 divided by 2000.

  • MONTH returns the intuitive understanding of the month of the year, and is useful primarily in other calculations rather than to extract the month from a known date, as that value is easily known from a plain reading of the entire date.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

DAY: Returns the day of the month that a specific date falls on, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the month as an integer for the given date value.

MINUTE - Docs Editors Help [gg-docs-en]

MINUTE

Returns the minute component of a specific time, in numeric format.

Sample Usage

MINUTE(TIME(11,40,59))

MINUTE(A2)

MINUTE(40909.0004)

MINUTE("20:49:59")

Syntax

MINUTE(time)

  • time - The time from which to calculate the minute component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as TIME, or a date serial number of the type returned by the N function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

  • MINUTE does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, MINUTE(12:00:00) will return an error.

  • MINUTE returns the intuitive understanding of minutes, and is useful primarily in other calculations rather than to extract the minute component of a known time, as that value is easily known from a plain reading of the entire time.

  • Note that date objects that are created with the DATE function or by entry of a date without a time component will have a time of 0:00:00.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

TIME: Converts an hour, minute, and second into a time.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

HOUR: Returns the hour component of a specific time, in numeric format.

DAY: Returns the day of the month that a specific date falls on, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the minute as an integer for the given time value.

How to shuffle music on your iPhone - Apple Support

How to shuffle music on your iPhone

You can ask Siri to turn shuffle on or off. Or you can manually turn shuffle on or off in the Apple Music app.

Ask Siri to shuffle music

You can easily turn shuffle on or off by asking Siri. Just say something like:

  • "Hey Siri, shuffle this album."
  • "Hey Siri, play my roadtrip playlist shuffled."
  • "Hey Siri, shuffle all of my songs."
  • "Hey Siri, turn off shuffle."

Learn more ways you can use Siri to play and control music.


How to shuffle an album or playlist

  1. Open the Apple Music app.
  2. Open an album or playlist.
  3. At the top of an album or playlist, tap the Shuffle button.
    iPhone showing the Shuffle button at the top of an album.

You can't turn off shuffle from here. Learn how to turn off shuffle.


How to shuffle all songs or albums in your library

  1. Open the Apple Music app.
  2. At the bottom of your screen, tap Library.
  3. Tap Songs or Albums.
  4. At the top of Songs or Albums, tap the Shuffle button.
    iPhone showing the Shuffle button at the top of Songs in Library.

You can't turn off shuffle from here. Learn how to turn off shuffle.


How to turn off shuffle

  1. Tap the song that's playing at the bottom of your screen.
  2. Tap the Playing Next button Playing Next button showing shuffle is on in the lower-right corner.
  3. Tap the Shuffle button Shuffle On button to turn Shuffle Off.
    iPhone showing shuffle is turned off on the Playing Next screen

When the Shuffle button isn't highlighted, shuffle is turned off.


If you don't see the Shuffle button


Learn how to shuffle music on more devices

Published Date: 

HOUR - Docs Editors Help [gg-docs-en]

HOUR

Returns the hour component of a specific time, in numeric format.

Sample Usage

HOUR(TIME(11,40,59))

HOUR(A2)

HOUR(40909.0004)

HOUR("20:49:59")

Syntax

HOUR(time)

  • time - The time from which to calculate the hour component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as TIME, or a date serial number of the type returned by the N function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

  • HOUR does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, HOUR(12:00:00) will return an error.

  • HOUR returns the intuitive understanding of hours, and is useful primarily in other calculations rather than to extract the hour component of a known time, as that value is easily known from a plain reading of the entire time.

  • Note that date objects that are created with the DATE function or by entry of a date without a time component will have a time of 0:00:00.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

TIME: Converts an hour, minute, and second into a time.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

MINUTE: Returns the minute component of a specific time, in numeric format.

DAY: Returns the day of the month that a specific date falls on, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the hour as an integer for the given date value.

DAY - Docs Editors Help [gg-docs-en]

DAY

Returns the day of the month that a specific date falls on, in numeric format.

Sample Usage

DAY(DATE(1969,7,20))

DAY(A2)

DAY(40909)

DAY("7/20/1969")

Syntax

DAY(date)

  • date - The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE, DATEVALUE or TO_DATE, or a date serial number of the type returned by the N function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

  • DAY does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, DAY(10/10/2000) is interpreted as DAY(0.005), the quotient of 10 divided by 10 divided by 2000.

  • DAY returns the intuitive understanding of the day of the month, and is useful primarily in other calculations rather than to extract the day of month from a known date, as that value is easily known from reading the entire date.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

MINUTE: Returns the minute component of a specific time, in numeric format.

HOUR: Returns the hour component of a specific time, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

DAY accepts different input parameter type.

See what friends are listening to in Apple Music on your iPhone, iPad, iPod touch, or Android device - Apple Support

See what friends are listening to in Apple Music on your iPhone, iPad, iPod touch, or Android device

If you subscribe to Apple Music, you can create a profile so your friends can see what you're listening to. And you can see what your friends are listening to.

An iPhone showing a user's profile in the Apple Music app. And a Mac showing the "Get Started" screen for creating a new profile in the Apple Music app.

Create a profile

  1. Open the Apple Music app.
  2. Tap Listen Now.
  3. In the upper-right corner of the Listen Now screen:
    • On your iPhone, iPad, or iPod touch, tap the photo icon the photo icon.
    • On your Android device, tap the More button the More button, then tap Account.
  4. Tap See What Friends Are Listening To.
  5. Follow the onscreen prompts to create a username, find and follow friends, share playlists, and more.
  6. Tap Done.


Manage what you share

You can choose to share the music that you're listening to with followers on your profile. If you make your listening history and playlists private, your profile picture and user name will still be visible in Search. To remove yourself entirely, delete your Apple Music profile.

View your profile

  1. Open the Apple Music app.
  2. Tap Listen Now.
  3. In the upper-right corner of Listen Now, tap the photo icon the photo icon or your photo.
  4. At the top of your screen, tap [your name] View Profile.

Share or hide your playlists

  1. At the top of your profile, tap Edit.
  2. Select the playlists that you want to share on your profile and in Search. And deselect the ones that you want to hide.
  3. Tap Done.

Hide music that you're listening to

To hide something that you're listening to, go to your profile, touch and hold an album or playlist, then tap Hide from Profile.

To hide all of the music that you're listening to:

  1. At the top of your profile, tap Edit.
  2. Scroll to the bottom, then follow the steps for your device:
    • On your iPhone, iPad, or iPod touch, turn off Listening To.
    • On your Android device, tap Additional Privacy Settings, then turn off Listening To.

Delete your profile

  1. Go to your profile.
  2. At the top of your profile, tap Edit.
  3. Scroll to the bottom of the screen and tap Delete Profile.

When you delete your profile, your user handle and music activity clear from Apple Music, but your Apple Music subscription isn't affected. If you shared a playlist with a friend and they saved it to their device, the playlist disappears. Your library and playlists don't change.


Find and follow friends

Here are a few ways you can find friends to follow:

  • Follow friends: At the bottom of your profile, tap Follow More Friends, then tap Follow next to a contact.
  • Search Apple Music: Go to Search, enter your friend's name, tap their name in the search results, then tap Follow at the top of their profile.

If someone requests to follow you, you can accept or decline the request at the top of your profile.

Sharing music with friends isn't available for Child accounts that are part of Family Sharing.

See what your friends are listening to

To see and play music that your friends are sharing, go to Listen Now, then scroll down to Friends Are Listening To.

To see a specific friend's profile, go to your profile, then tap their photo under Followers or Following. From here, you can see their shared playlists and what they're listening to.

Unfollow and block users

  1. Go to your profile.
  2. Under Following or Followers, tap a person to go to their profile.
  3. On the right side of their profile, tap the More button the more button.
    • Tap Unfollow to stop following them.
    • Tap Block to block a user from seeing your profile. People that you block won't see your music or find your profile in Apple Music.


Report a concern

If you see something offensive on a user's profile or in an user-created playlist, you can report it to Apple and we'll investigate the issue. You can report a concern with any content that an Apple Music user uploads or shares.

Items that you can report include:

  • Playlist names
  • Playlist images
  • Playlist descriptions
  • User names
  • User images
  • User handles

To report an offensive name or image:

  1. Go to the user's page or playlist's page.
  2. On your iPhone, iPad, iPod touch, tap the More button the more button.  On your Android device, tap the More button the more button.
  3. Choose Report a Concern.

Sharing music with friends isn't available in Cameroon, China mainland, Malawi, Mali, Russia, Turkey, and Uruguay.

Published Date: 

DATEVALUE - Docs Editors Help [gg-docs-en]

DATEVALUE

Converts a provided date string in a known format to a date value.

Examples

Make a copy

DATEVALUE accepts different input string format.

Sample Usage

DATEVALUE("1969-7-20")

DATEVALUE("7/20/1969")

DATEVALUE(A2)

Syntax

DATEVALUE(date_string)

  • date_string - The string representing the date.

    • Understood formats include any date format which is normally autoconverted when entered, without quotation marks, directly into a cell. Understood formats may depend on region and language settings.

Notes

  • The input to DATEVALUE must be a string - if a number or cell reference to a cell containing a number is provided, the #VALUE! error will be returned.

  • DATEVALUE returns integers that can be used in formulas. To get dates, change the cell format to Date

  • If providing an explicit string input to DATEVALUE rather than a cell reference, surrounding quotation marks are required.

  • Some date formats are not understood by Google Sheets. To quickly ensure that the desired date format is understood, type an example of it into an empty cell, without quotation marks.

See Also

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

DATE: Converts a year, month, and day into a date.

DEC2BIN - Docs Editors Help [gg-docs-en]

DEC2BIN

The DEC2BIN function converts a decimal number to signed binary format.

Sample Usage

DEC2BIN("100",8)

DEC2BIN(A2)

Syntax

DEC2BIN(decimal_number, [significant_digits])

  • decimal_number - The decimal value to be converted to signed binary, provided as a string.

    • For this function, this value has a maximum of 511 if positive, and a minimum of -512 if negative.

    • If decimal_number is provided as a valid decimal number, it will automatically be converted to the appropriate string input. For example, DEC2BIN(199) and DEC2BIN("199") yield the same result: 11000111.

  • significant_digits - [ OPTIONAL ] The number of significant digits to ensure in the result.

    • If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches significant_digits.

    • This value is ignored if decimal_number is negative.

Notes

  • If the number of digits required is greater than the specified significant_digits, the #NUM! error is returned.

  • Ensure that any calculations using the result of DEC2BIN take into account that it is in binary. Results will be silently converted by Google Sheets; thus if cell A2 contains 11111, the binary equivalent of the decimal value 31, and B2 contains a formula such as =A2+9, the result will be 11120, which is incorrect in binary calculation.

See Also

OCT2HEX: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

OCT2DEC: The OCT2DEC function converts a signed octal number to decimal format.

OCT2BIN: The OCT2BIN function converts a signed octal number to signed binary format.

HEX2OCT: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

HEX2DEC: The HEX2DEC function converts a signed hexadecimal number to decimal format.

HEX2BIN: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

DEC2OCT: The DEC2OCT function converts a decimal number to signed octal format.

DEC2HEX: The DEC2HEX function converts a decimal number to signed hexadecimal format.

BIN2OCT: The BIN2OCT function converts a signed binary number to signed octal format.

BIN2HEX: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

BIN2DEC: The BIN2DEC function converts a signed binary number to decimal format.

Examples

Converts a decimal number to its binary value.

BIN2OCT - Docs Editors Help [gg-docs-en]

BIN2OCT

The BIN2OCT function converts a signed binary number to signed octal format.

Sample Usage

BIN2OCT(101,8)

BIN2OCT(A2)

Syntax

BIN2OCT(signed_binary_number, [significant_digits])

  • signed_binary_number - The signed 10-bit binary value to be converted to signed octal, provided as a string.

    • The most significant bit of signed_binary_number is the sign bit; that is, negative numbers are represented in two's complement format.

    • For this function, this value has a maximum of 0111111111 if positive, and a minimum of 1000000000 if negative.

    • If signed_binary_number is provided as a valid binary number, it will automatically be converted to the appropriate string input. For example, BIN2OCT(11111) and BIN2OCT("11111") yield the same result: 37.

  • significant_digits - [ OPTIONAL ] - The number of significant digits to ensure in the result.

    • If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches significant_digits. For example, BIN2OCT("11111") yields the value 00000037.

    • This value is ignored if the most significant bit of signed_binary_number is 1; that is, if the expressed signed_binary_number is greater than or equal to 1000000000.

Notes

  • As with any binary value, only the digits 0 and 1 are valid. Digits other than these will cause BIN2OCT to return a #NUM! error.

  • If the number of digits required is greater than the specified significant_digits, the #NUM! error is returned.

  • Ensure that any calculations using the result of BIN2OCT take into account that it is in octal. Results will be silently converted by Google Sheets; thus if cell A2 contains 111, the octal equivalent of binary 1001001, and B2 contains a formula such as =A2+9, the result will be 120, which is incorrect in octal calculation.

See Also

OCT2HEX: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

OCT2DEC: The OCT2DEC function converts a signed octal number to decimal format.

OCT2BIN: The OCT2BIN function converts a signed octal number to signed binary format.

HEX2OCT: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

HEX2DEC: The HEX2DEC function converts a signed hexadecimal number to decimal format.

HEX2BIN: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

DEC2OCT: The DEC2OCT function converts a decimal number to signed octal format.

DEC2HEX: The DEC2HEX function converts a decimal number to signed hexadecimal format.

DEC2BIN: The DEC2BIN function converts a decimal number to signed binary format.

BIN2HEX: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

BIN2DEC: The BIN2DEC function converts a signed binary number to decimal format.

Examples

Converts a binary number to its octal value.

BIN2DEC - Docs Editors Help [gg-docs-en]

BIN2DEC

The BIN2DEC function converts a signed binary number to decimal format.

Sample Usage

BIN2DEC(101)

BIN2DEC(A2)

Syntax

BIN2DEC(signed_binary_number)

  • signed_binary_number - The signed 10-bit binary value to be converted to decimal, provided as a string.

    • The most significant bit of signed_binary_number is the sign bit; that is, negative numbers are represented in two's complement format.

    • For this function, the input value has a maximum of 0111111111 if positive, and a minimum of 1000000000 if negative.

    • If signed_binary_number is provided as a valid binary number, it will automatically be converted to the appropriate string input. For example, BIN2DEC(100) and BIN2DEC("100") yield the same result: 4.

Notes

  • As with any binary value, only the digits 0 and 1 are valid. Digits other than these will cause BIN2DEC to return a #NUM! error.

See Also

OCT2HEX: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

OCT2DEC: The OCT2DEC function converts a signed octal number to decimal format.

OCT2BIN: The OCT2BIN function converts a signed octal number to signed binary format.

HEX2OCT: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

HEX2DEC: The HEX2DEC function converts a signed hexadecimal number to decimal format.

HEX2BIN: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

DEC2OCT: The DEC2OCT function converts a decimal number to signed octal format.

DEC2HEX: The DEC2HEX function converts a decimal number to signed hexadecimal format.

DEC2BIN: The DEC2BIN function converts a decimal number to signed binary format.

BIN2OCT: The BIN2OCT function converts a signed binary number to signed octal format.

BIN2HEX: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

Examples

Converts a binary number to its decimal value.

Subscribe to iTunes Match - Apple Support

Subscribe to iTunes Match

iTunes Match gives you access to all of your music on all of your devices, even songs that you've imported from other sources such as CDs.

A Mac showing the subscribe to iTunes Match screen in the Apple Music app.

If you have an Apple Music membership, you get all of the benefits of iTunes Match, plus access to the entire Apple Music catalog. You can also get a Family Membership to share the catalog with your family members. Learn more about joining Apple Music.

About iTunes Match

iTunes Match uploads your music library from the Apple Music app on your Mac or iTunes for Windows on your PC. Then you can access your music library on all of your devices that have Sync Library turned on.

To subscribe to iTunes Match, update your Mac to the latest version of macOS. On your PC, make sure that you have the latest version of iTunes for Windows.

iTunes Match isn't a back up service, so make sure to always have a back up of your music collection before you make any changes.


Subscribe to iTunes Match

  1. On your Mac, open the Apple Music app. On your PC, open iTunes for Windows.
  2. On your Mac, go to the sidebar and click iTunes Store. Don't see the iTunes Store on your Mac? On your PC, click Store at the top of the iTunes window.
  3. Scroll to the bottom of the Store window. Under Features, click iTunes Match.
    The Apple Music app shows that iTunes Match is located at the bottom of the iTunes Store.
  4. Click the Subscribe button.
  5. Sign in with the Apple ID and password.
  6. Confirm your billing information. You might need to add a valid payment method. Then click Subscribe.

After you subscribe, iTunes Match automatically scans your music library for matches. A status indicator lets you track the scan's progress. You can manually pause and resume the scan at any time by clicking the Stop or Start button. If your Mac or PC disconnects from the Internet during the upload process, iTunes Match will automatically resume where it left off the next time you open the Apple Music app or iTunes for Windows.

Once your music library is uploaded, you'll see Download the Download icon next to songs that are available for download from iCloud. If you don't see the download icon, the song is already in your local music library.

If you don't see the iTunes Store on your Mac

In the latest version of macOS, the iTunes Store might be hidden. Here's how to find it:

  1. In the Apple Music app, go to the menu bar and choose Music > Preferences.
  2. Go to the General tab and select iTunes Store.
  3. Click OK.


Cancel your iTunes Match subscription

By default, your iTunes Match subscription automatically renews at the end of your one-year subscription. Learn how to cancel your subscription.


Use iTunes Match

To access your songs and playlists on other devices, turn on Sync Library on all of your devices.

When you sign in with the Apple ID that you use with iTunes Match on your iPhone, iPad, iPod touch, Mac, or PC, you associate that device with your account and get access to your music library.

It might take some time for iTunes Match to upload your music from your Mac or PC. If you don't see your music on another device right away, check back later. When iTunes Match is finished uploading your music library, Download the Download icon appears next to music that's been uploaded.

iTunes Match isn't available for Android devices.


Learn more

iTunes Match availability varies by country and region.

Information about products not manufactured by Apple, or independent websites not controlled or tested by Apple, is provided without recommendation or endorsement. Apple assumes no responsibility with regard to the selection, performance, or use of third-party websites or products. Apple makes no representations regarding third-party website accuracy or reliability. Contact the vendor for additional information.

Published Date: 

YEARFRAC - Docs Editors Help [gg-docs-en]

YEARFRAC

Returns the number of years, including fractional years, between two dates using a specified day count convention.

Sample Usage

YEARFRAC(DATE(1969,7,16),DATE(1969,7,24),1)

YEARFRAC(A2,A3)

Syntax

YEARFRAC(start_date, end_date, [day_count_convention])

  • start_date - The start date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

  • end_date - The end date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

  • day_count_convention - [ OPTIONAL - 0 by default ] - An indicator of what day count method to use.

    • 0 indicates US (NASD) 30/360 - This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard, and performs specific adjustments to entered dates which fall at the end of months.

    • 1 indicates Actual/Actual - This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years. Used for US Treasury Bonds and Bills, but also the most relevant for non-financial use.

    • 2 indicates Actual/360 - This calculates based on the actual number of days between the specified dates, but assumes a 360 day year.

    • 3 indicates Actual/365 - This calculates based on the actual number of days between the specified dates, but assumes a 365 day year.

    • 4 indicates European 30/360 - Similar to 0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

Notes

  • This function is mostly used in a financial setting, for calculation involving fixed-income securities. Because the most common calculations performed use the NASD standard calendar, this is the default behavior. However, for use in non-financial settings, option 1, Actual/Actual, is most likely the correct choice.

  • Ensure that the inputs to the function are either references to cells containing dates, functions which return date objects such as DATE, DATEVALUE or TO_DATE, or date serial numbers of the type returned by the N function.

  • YEARFRAC does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, YEARFRAC(10/10/2000,10/10/2001) is interpreted as YEARFRAC(0.005,0.00499750124938), the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.

See Also

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

DAYS360: Returns the difference between two days based on the 360-day year used in some financial interest calculations.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Calculates the fraction of a year between start_date and end_date using different day_count_conventions.

Calculates a person's age by combining the YEARFRAC and TODAY functions, then applying ROUNDDOWN to the result to return the number of years.

Newer Posts Older Posts Home

Search This Blog

Review changes with Track Markup [MS]

Review changes with Track Markup Visio Plan 2 Visio Professional 2021 ...