Ada beberapa formula keuangan dalam excel diantaranya adalah : Fv | Ipmt | Npv | Pmt | Ppmt
------------------------------------

Fv
What is the use of Fv formula?
Finds out how much a series of payments is worth in future

Syntax of Fv formula:
fv(at this rate, this many payments, of each)

Examples of Excel Fv formula:
fv(10%,12,-1000) = 21,384.28
------------------------------------

Ipmt
What is the use of Ipmt formula?
Tells you how much of your mortgage goes towards interest in specified month

Syntax of Ipmt formula:
ipmt(at this rate, on this payment, out of this many payments, for this much amount)

Examples of Excel Ipmt formula:
ipmt(10%,3,12,-100000) = 9017.97
------------------------------------

Npv
What is the use of Npv formula?
Calculates net present value from a series of future payments

Syntax of Npv formula:
npv(at this rate, list of payments)

Examples of Excel Npv formula:
npv(10%,100,100,100,100,100) = 379.07
------------------------------------

Pmt
What is the use of Pmt formula?
Tells you how much you should pay on your mortage (every month ..)

Syntax of Pmt formula:
pmt(at this rate, this many payments, for this much amount)

Examples of Excel Pmt formula:
pmt(10%,12,-100000) = 14676.33
------------------------------------

Ppmt
What is the use of Ppmt formula?
Tells you how much of your mortgage goes towards principle in specified month

Syntax of Ppmt formula:
ppmt(at this rate, on this payment, out of this many payments, for this much amount)

Examples of Excel Ppmt formula:
ppmt(10%,3,12,-100000) = 5658.36
------------------------------------

Sumber : http://chandoo.org/

Formula Finansial dalam Excel

Ada beberapa Formula Tanggal dan Waktu diantaranya : Day | Hour | Minute | Month | Networkdays | Now | Second | Today | Weekday | Year
--------------------------------------

Day
What is the use of Day formula?
Tells you the day of month from a given date

Syntax of Day formula:
day(of this date)

Examples of Excel Day formula:
day("12/31/1981") = 31
day(today()) = current day
--------------------------------------

Hour
What is the use of Hour formula?
Tells you the hour from a given time

Syntax of Hour formula:
hour(at this time)

Examples of Excel Hour formula:
hour("11:30") = 11
hour(now()) = current hour
--------------------------------------

Minute
What is the use of Minute formula?
Tells you the minutes from a given time

Syntax of Minute formula:
minute(at this time)

Examples of Excel Minute formula:
minute("11:30") = 30
minute(now()) = current minutes
--------------------------------------

Mounth
What is the use of Month formula?
Tells you the month from a given date

Syntax of Month formula:
month(of this date)

Examples of Excel Month formula:
month("12/31/1981") = 12
month(today()) = current month
--------------------------------------

Networkdays
What is the use of Networkdays formula?
Tells you how many working days are there between 2 given dates

Syntax of Networkdays formula:
networkdays(from this date, to this date, [add this holidays as well])

Examples of Excel Networkdays formula:
networkdays("12/1/2008","12/31/2008") = 23
networkdays(TODAY(),TODAY()+30) = total working days in next 30 days
--------------------------------------

Now
What is the use of Now formula?
Today's date along with current time

Syntax of Now formula:
now()

Examples of Excel Now formula:
now() = today's date along with current time
--------------------------------------

Second
What is the use of Second formula?
Tells you the seconds from a given time

Syntax of Second formula:
second(at this time)

Examples of Excel Second formula:
second("11:30:45") = 45
second(now()) = current seconds
--------------------------------------

Today
What is the use of Today formula?
Today's date

Syntax of Today formula:
today()

Examples of Excel Today formula:
today() = today's date
--------------------------------------

Weekday
What is the use of Weekday formula?
Tells you the day of week from a given date

Syntax of Weekday formula:
weekday(of this date)

Examples of Excel Weekday formula:
weekday("12/12/1981") = 7
weekday(today()) = current day of week
--------------------------------------

Year
What is the use of Year formula?
Tells you the year from a given date

Syntax of Year formula:
year(of this date)

Examples of Excel Year formula:
year("12/31/1981") = 1981
year(today()) = current year

--------------------------------------

Sumber : http://chandoo.org/

Formula Tanggal dan Waktu

Ada beberapa fungsi logika dalam microsoft excel. beberapa diantaranya adalah 
And | Countblank | Countif | If | Large | Max | Min | Not | Or | Small | Sumif | Vlookup----------------------------

And
What is the use of And formula?
Checks whether all conditions are passed or not

Syntax of And formula:
and(list of conditions)

Examples of Excel And formula:
and(true, false) = false
and(true, true) = true
----------------------------

Countblank
What is the use of Countblank formula?
Counts blank cells in a given list

Syntax of Countblank formula:
countblank(in this list)

Examples of Excel Countblank formula:
countblank(list) = number of blank cells in the list
----------------------------

Countif
What is the use of Countif formula?
Counts of items in a list matching a condition

Syntax of Countif formula:
countif(in this range, values meeting this criteria)

Examples of Excel Countif formula:
countif(A1:A20, 1) = counts how many cells have "1"
countif(A1:A20, "<3") = counts how many cells have less than 3
----------------------------

If
What is the use of If formula?
Fetches one of the two values based on a condition

Syntax of If formula:
if(is-this-true?, do this, or this)

Examples of Excel If formula:
if(5<10,"hello","world") = hello
if(5>10,"hello","world") = world
----------------------------

Large
What is the use of Large formula?
Finds the nth largest number in a list

Syntax of Large formula:
large(from this list, nth largest number)

Examples of Excel Large formula:
large(list, 2) = 2nd largest number in the list
----------------------------

Max
What is the use of Max formula?
Finds the maximum of a given list of numbers

Syntax of Max formula:
max(of this list of numbers)

Examples of Excel Max formula:
max(1,2,3) = 3
max(A1:A20) = maximum value in the range A1:A20
----------------------------

Min
What is the use of Min formula?
Finds the minimum of a given list of numbers

Syntax of Min formula:
min(of this list of numbers)

Examples of Excel Min formula:
min(1,2,3) = 1
min(A1:A20) = minimum value in the range A1:A20
----------------------------

Not
What is the use of Not formula?
Negates a logical value

Syntax of Not formula:
not(this logical value)

Examples of Excel Not formula:
not(false) = true
not(not(false)) = false
----------------------------

OrWhat is the use of Or formula?
Checks whether any condition is met

Syntax of Or formula:
or(list of conditions)

Examples of Excel Or formula:
or(true, false) = true
or(false, false) = false
----------------------------

Small
What is the use of Small formula?
Finds the nth smallest number in a list

Syntax of Small formula:
small(from this list, nth smallest number)

Examples of Excel Small formula:
small(list, 2) = 2nd smallest number in the list
----------------------------

Sumif
What is the use of Sumif formula?
Sums items in a list matching a condition

Syntax of Sumif formula:
sumif(in this range, values meeting this criteria, [sum-this-range])

Examples of Excel Sumif formula:
sumif(A1:A20, 3) = sums the cells with a value of "3"
sumif(A1:A20, 3, b1:b20) = same as above but adds values in B1:B20
----------------------------

Vlookup

What is the use of Vlookup formula?
Searches a list for a value you are looking for and returns a corresponding value

Syntax of Vlookup formula:
vlookup(this value, in this list, and get me value in this column, [is-my-list-sorted?])

Examples of Excel Vlookup formula:
vlookup("John", list, 2, false) = finds where Jon is in the list and returns the value in the 2nd column

Sumber : http://chandoo.org/

Fungsi Logika dalam Microsoft Excel

Ada beberapa Formula matematika diantaranya yaitu Average, Int, Mod, Rand, Round dan Sum 

-----------------------------------

Average

FormulaWhat is the use of Average formula?

Average of given numbers

Syntax of Average formula:
average(of this number, [and this number too..])

Examples of Excel Average formula:
average(2,4,6) = 4
average(A1:A5) = average of numbers in A1:A5
-----------------------------------

Int
What is the use of Int formula?
Converts a decimal number to integer lower than it

Syntax of Int formula:
int(this number)

Examples of Excel Int formula:
int(1.2365) = 1
----------------------------------

Mod
What is the use of Mod formula?
Tells you what is the reminder after dividing one number with another

Syntax of Mod formula:
mod(of this number, divided by this number)

Examples of Excel Mod formula:
mod(5,3) = 2
mod(3,5) = 3
----------------------------------

Rand
What is the use of Rand formula?
Gives you a random number to play with

Syntax of Rand formula:
rand()

Examples of Excel Rand formula:
rand() = who knows
----------------------------------

Round

What is the use of Round formula?
Rounds a number to nearest decimal you specify

Syntax of Round formula:
round(this number, to this many digits after decimal)

Examples of Excel Round formula:
round(1.2365,0) = 1
round(1.2365,2) = 1.24
----------------------------------

Sum
What is the use of Sum formula?
Adds a bunch of numbers


Syntax of Sum formula:
sum(add this, [and this ..])

Examples of Excel Sum formula:
sum(1,2,3,4) = 10
sum(5.6,2.3) = 7.9

Sumber : http://chandoo.org/

Formula Matematika dalam Excel