Numbers 3.6.2 Download
Numbers 3 6 9 And Magnets
Numbers 36 1

DATE

Decimals (decimal numbers) enter with a decimal point. And they are automatically converted to fractions - i.e. The colon: and slash / is the symbol of division. Can be used to divide mixed numbers 1 2/3: 4 3/8 or can be used for write complex fractions i.e. An asterisk. or × is the symbol for multiplication. A mixed number is a whole number plus a fractional part. An improper fraction is a fraction where the numerator (top number) is larger than the denominator (bottom number). You can convert between mixed numbers and improper fractions without changing the value of the figure. Example: Convert the following mixed number to an improper fraction.

Combines separate values for year, month, and day and returns a date/time value.

DATEDIF

Returns the number of days, months, or years between two dates.

DATEVALUE

Converts a date text string and returns a date/time value. This function is provided for compatibility with other spreadsheet programs.

DAY

Returns the day of the month for a given date/time value.

DAYNAME

Returns the name of the day of the week from a date/time value or a number. Day 1 is Sunday.

DAYS360

Returns the number of days between two dates based on twelve 30‑day months and a 360‑day year.

EDATE

Returns a date that is some number of months before or after a given date.

EOMONTH

Returns a date that is the last day of the month some number of months before or after a given date.

HOUR

Returns the hour for a given date/time value.

MINUTE

Returns the minutes for a given date/time value.

MONTH

Returns the month for a given date/time value.

MONTHNAME

Returns the name of the month from a number. Month 1 is January.

NETWORKDAYS

Returns the number of working days between two dates. Working days exclude weekends and any other specified dates.

NOW

Returns the current date/time value from the system clock.

SECOND

Returns the seconds for a given date/time value.

TIME

Converts separate values for hours, minutes, and seconds into a date/time value.

TIMEVALUE

Returns the time as a decimal fraction of a 24‑hour day from a given date/time value or from a text string.

TODAY

Returns the current system date. The time is set to 12:00 a.m.

WEEKDAY

Returns a number that is the day of the week for a given date.

WEEKNUM

Returns the number of the week within the year for a given date.

WORKDAY

Returns the date that is the given number of working days before or after a given date. Working days exclude weekends and any other dates specifically excluded.

YEAR

Returns the year for a given date/time value.

YEARFRAC

Finds the fraction of a year represented by the number of whole days between two dates.

DUR2DAYS

Converts a duration value to a number of days.

DUR2HOURS

Converts a duration value to a number of hours.

DUR2MILLISECONDS

Converts a duration value to a number of milliseconds.

DUR2MINUTES

Converts a duration value to a number of minutes.

DUR2SECONDS

Converts a duration value to a number of seconds.

DUR2WEEKS

Converts a duration value to a number of weeks.

DURATION

Combines separate values for weeks, days, hours, minutes, seconds, and milliseconds and returns a duration value.

STRIPDURATION

Evaluates a given value and returns either the number of days represented, if a duration value; or the given value. This function is included for compatibility with other spreadsheet applications.

BASETONUM

Converts a number of the specified base into a number in base 10.

BESSELJ

Returns the integer Bessel function Jn(x).

BESSELY

Returns the integer Bessel function Yn(x).

BIN2DEC

Converts a binary number to the corresponding decimal number.

BIN2HEX

Converts a binary number to the corresponding hexadecimal number.

BIN2OCT

Converts a binary number to the corresponding octal number.

CONVERT

Converts a number from one measurement system to its corresponding value in another measurement system.

DEC2BIN

Converts a decimal number to the corresponding binary number.

DEC2HEX

Converts a decimal number to the corresponding hexadecimal number.

DEC2OCT

Converts a decimal number to the corresponding octal number.

DELTA

Determines whether two values are exactly equal.

ERF

Returns the error function integrated between two values.

ERFC

Returns the complementary ERF function integrated between a given lower bound and infinity.

GESTEP

Determines if one value is greater than or exactly equal to another value.

HEX2BIN

Converts a hexadecimal number to the corresponding binary number.

HEX2DEC

Converts a hexadecimal number to the corresponding decimal number.

HEX2OCT

Converts a hexadecimal number to the corresponding octal number.

NUMTOBASE

Converts a number from base 10 into a number in the specified base.

OCT2BIN

Converts an octal number to the corresponding binary number.

OCT2DEC

Converts an octal number to the corresponding decimal number.

OCT2HEX

Converts an octal number to the corresponding hexadecimal number.

ACCRINT

Calculates the accrued interest added to the purchase price of a security and paid to the seller when the security pays periodic interest.

ACCRINTM

Calculates the total accrued interest added to the purchase price of a security and paid to the seller when the security pays interest only at maturity.

BONDDURATION

Calculates the weighted average of the present value of the cash flows for an assumed par value of $100.

BONDMDURATION

Calculates the modified weighted average of the present value of the cash flows for an assumed par value of $100.

COUPDAYBS

Returns the number of days between the beginning of the coupon period in which settlement occurs and the settlement date.

COUPDAYS

Returns the number of days in the coupon period in which settlement occurs.

COUPDAYSNC

Returns the number of days between the settlement date and the end of the coupon period in which settlement occurs.

COUPNUM

Returns the number of coupons remaining to be paid between the settlement date and the maturity date.

CUMIPMT

Returns the total interest included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.

CUMPRINC

Returns the total principal included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.

CURRENCY

Returns data from the previous market day’s close about the exchange rate between two currencies, retrieved remotely via the Internet.

CURRENCYCODE

Returns the ISO currency code of a given currency value, or the currency code for the language and region set for the computer or for the current document.

CURRENCYCONVERT

Returns the price of a given currency value in a different currency, using exchange rate data from the previous market day’s close, retrieved remotely via the Internet.

CURRENCYH

Returns historical data on the exchange rate between two currencies for a given date. The value returned is in the target currency (the currency to which you’re converting).

DB

Returns the amount of depreciation of an asset for a specified period using the fixed‑declining balance method.

DDB

Returns the amount of depreciation of an asset based on a specified depreciation rate.

DISC

Returns the annual discount rate of a security that pays no interest and is sold at a discount to its redemption value.

EFFECT

Returns the effective annual interest rate from the nominal annual interest rate based on the number of compounding periods per year.

FV

Returns the future value of an investment based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.

INTRATE

Returns the effective annual interest rate for a security that pays interest only at maturity.

IPMT

Returns the interest portion of a specified loan or annuity payment based on fixed, periodic payments and a fixed interest rate.

IRR

R

Numbers 3.6.2