Conditional Formatting In Open Office Calc.

How to use conditional formatting in calc.

First, we need a new formating style.

To do this we need to pick any cell in our sheet and apply what style we want. For this example, I chose to set the background color to yellow. Then, on the Format menu we need to click
Styles and Formatting.




The Styles and Formatting box now appears. Then click on the New Style From Selection Button.



When the Create Style box comes up, you can name your new style. I called mine yellow.



Now highlight your data that you want to apply the conditional formatting to. Then on the Format menu, click Conditional Formatting. I decided I wanted to highlight the values between $20,000 and $28,000.




After you click OK, your data is highlighted.



The data is prices on makes of different sports cars that I made up. To generate the data, I used the RANDBETWEEN() function.

How to insert a graph into a spreadsheet

Here is a great program you can use by itself or with an office suite program. It is called Graph. It is free. Here is the link to download it.

After you have installed Graph, open Calc.

Goto Insert > Object > OLE Object... and you will get a box like this.



You then need to double click Further objects. You will then get this box.



Once this box is up, you need to click on Graph System and then hit OK.

This will show on your screen. It might show you a tip of the day. You can just close that.



You can then enter the function you want to graph and then close the graph window. And there you have it. A graph.

I have a video on You Tube explaining this. The video is done with Excel 2007. Below is the link. Enjoy.

Video on You Tube

Sports Stats in Spreadsheet

I have created spreadsheets for Major League Baseball, NASCAR, Tennis, and Golf to keep track of stats. The spreadsheets are linked to external data. You can update the data from the spreadsheet. You can see my video on You Tube to see how this is done. If there are other sports you would like done, please leave a comment.

Look under "Links" on the right hand side of the page and click on "Spreadsheet Files".

MLB Stats

I just posted a file to keep up with MLB stats. You can get the file by clicking on "Spreadsheet Files" under "Links" on the right hand side of the page.

Here is a video I made on Linking to External Data.

Video

Group and Link to External Data

I just posted a video on You Tube about grouping data in a spreadsheet. The data is from Yahoo! Sports. I got the data in the spreadsheet by Linking To External Data. I also have a video posted explaining this. Watch and enjoy. Learn how keep up with your favorite sports stats easily, in a spreadsheet.

Here are the links:
Linking to external data
Grouping the data

MINVERSE and MMULT

Looking for an easy way to solve a system of equations? Calc can can do this for you.

Functions used:

MINVERSE(Array)
MMULT(Array,Array)

Let's look at each function individually:

MINVERSE(Array) - This function calculates the inverse of a square array. Square array means the array has the same number of rows as it does columns.

MMULT(Array,Array) = This function calculates the product of two arrays. The number of columns in the first array must be the same as the number of rows in the second array.

Take a look at the screen shots below. I have posted this file. It is called system of equations. You download by clicking on "Spreadsheet Function Files" under "Links" on the right hand side of the page.

This screen shot is for cells A13:C15



This screen shot is for cells B18:B20



And here is a screen shot of my results. The answers are in cells B18:B20

Validity video on You Tube

I just uploaded two videos on You Tube about using Validity in the Data menu. These are great videos showing you how to access list on another sheet and another file. It also includes using the OFFSET and MATCH functions in calc.

Here are the links. I hope you enjoy them.

http://www.youtube.com/watch?v=UVt6LiwbtEE

http://www.youtube.com/watch?v=N8YHWDTUshA

What do I do? Excel freezes up.

I know this works in excel 2002. It should work in other versions.

Problem:
You open excel, it freezes up your computer and says there is not enough memory.


Fix:
Uninstalling excel will and reinstalling will not fix this problem. More than likely, the menu file is corrupt. With excel closed, open windows explorer and do a search for ".xlb" without the quotes. This is your menu file. Once the file shows up in the search, you need to delete it. The file you are looking for is Excel.xlb. Close windows explorer, open excel, and it is fixed.

Karate students take out robber

There are some stupid criminal in the world, but this has to be one of the best stories I've read.

It's been a bad few days for criminals. Not only did a mugger in Germany get taken down by a blind judo champion, but an armed robber in Colombia found out the hard way that a karate academy is a lousy place to try and rob.

Here is the link.

YouTube launches virtual screening room for indie films

Get your cameras out and make a movie.

Google's YouTube is setting up a virtual screening room to bring the work of independent filmmakers to a global audience.

Here is the link.

EBay strengthens PayPal's anti-fraud provisions

EBay hopes to attract more online traders by expanding the protections available to people who use its PayPal payment service for transactions on eBay's Internet marketplaces.

EBay executives said Thursday at the company's annual user conference that buyers who pay for items with PayPal will be eligible for full refunds, with no cap, if a seller fails to deliver an item as promised. Previously a buyer's coverage was capped at $200, or $2,000 if the item's seller enjoyed a particularly good reputation on eBay.

EBay sellers who accept PayPal as a payment method — as nearly all of them do — will also get unlimited protection against a charge being reversed.

Fortunately, I have never had a problem with paypal. Woops, I better knock on wood.

Here is the link.

Snake in the road

Me and the wife were driving home the other night and saw something shiny in the middle of the road. Out of curiosity, we had to back up and see. Well it was a snake. We got a good look at it when we got out of the car. After extensive research on the internet, we came to the conclusion it was a mud snake. Here is a photo. It is not the actual snake, just a random mud snake.

Switch Pitcher?

Switch hitters better watch out.

Things got a tad dizzying when designated hitter Ralph Henriquez, who had taken his on-deck circle swings as a lefty, entered the batter's box from the right side.

Venditte put his specially made glove (it has six fingers, two webs and fits on both hands) on his left hand, and got ready to pitch right-handed.

Here is the link.

Python in the toilet

This is not the actual snake. This is just some random picture.

Be careful when you go to restroom. A 6 foot python slithers out of a 10th floor apartment toilet in Australia.

"When I saw it I was pretty shocked," Peberdy told the Northern Territory News. "It's one thing in the Territory to have a green frog in the toilet ... but not a six-foot python. It would certainly scare you if it came up from the depths of the toilet.”

I think it would scare me also.

Here is the link.

Three-Dimensional TV to Japan

Get the 3D glasses out. Hyundai is offering 3D televisions in Japan only. Wonder how long it will take for them to get to everyone?



Price = $3,960 (But it does include 2 pair of 3D glasses)

Your sleeping problems at work are over

Ever get tired at work or school. Well look no further. The pilo is here. It is a tiny pillow on a ring. You should be able to rest comfortably now.


Here is someone enjoying a nap.



Here is the link.

I am Back

We are back. Gone for a little while turned into gone for a while. What a day we had.

We went to the in-laws and had a wonderful lunch. We had beef cube steak smothered in gravy and rice. It was delicious.

Finally, we got in the truck. We started our venture to get the RV, which was about 45 minutes away on another lot my in-laws own. Everything was going great. We were having a great time.

Now we arrive at the lot where the RV is. So we have a few things to get cleaned up. There was debris on the roof that we had to get off before we could retract the sides back in. The water and sewage line also had to be unhooked. My mother in-law and wife were inside securing loose items. After about an hour, everything is ready. So we hookup the RV and we are off to our destination, Stamps, Arkansas (about 2 hour away).

Now the real fun begins. The tires on the RV need air, so we stop at the store and air pump (I was shocked that air costs 75 cents now) does not work. No big deal, we will just stop and next station a few mile up the road. Next, we pull into station number 2. Yeah, the air pump works and it is free air. I start airing up the tires and my father-in-law is check the air pressure. All of a sudden we here bam. The valve stem broke on one of the tires form being dry rotted. We get the jack and spare tire and after about 20 minutes we ready to go.

With everything ready and aired up, we are off to Stamps. We are cruising along when all of a sudden a lady pulls up beside us and starts pointing. So we pull over onto the shoulder of the road. OH ****!!! A tire blew out!!! Wondering what we are going to do, this nice man pulls up and asks us if we need any help. And guess what? He owns a tire store. It takes about 1 1/2 hours to fix the tires and get back on the road.

We finally arrive at our destination. Nothing else happened. The only other thing we did was eat at Burger King. Then we finally arrived back home about 1:30 a.m.

Gone for a little while today

Hopefully I will be able to make some posts later this evening. Right now, I am going to help the in-laws move their RV.

Check out my videos

I have 10 videos posted on you tube. They are computer related video tutorials. You can go to You Tube and do a search for "sc092270" and they should all come up.

I am using camstudio to make the videos. It is free software you can download. I hope you enjoy them.

If you have any requests for a video, please post your request in the comments.

Get it off my chest Friday

How about we start a post every Friday where you can talk about what ever you want.

Woman From 'Pacman' Fight Found Dead

The woman form the Pacman fight is found dead in N.Y. The cause of death has not been determined.

Here is the link.

Trying to take over Anheuser-Busch

Budweiser no longer an American beer? Oh no! What horror! A Belgian brewery is trying to take over Anheuser-Busch.



That's just one of many reasons beverage sector experts -- and more than a few Bud drinkers -- are rolling their eyes at an audacious play by Belgian brewery giant InBev for Anheuser-Busch (BUD, news, msgs). The St. Louis company makes the iconic Budweiser brand that's as American as hot dogs, baseball and apple pie.

Here is the link.

Don't tail gate drivers with bumber stickers

People with bumper stickers are more likely to have road rage. I guess, since I do not have a bumper sticker, I don't have road rage.

I used to think that the most dangerous thing about bumper stickers was that they make curious drivers inch ever closer to the car in front of them in order to read the things (“He Put the Duh in W,” perhaps, or “At Least the War on the Environment is Going Well,” or “49% ***, 51% Sweetheart; Don’t Push It,” or “If There Is a Tourist Season, Why Can’t We Shoot Them?”—for all of which I am indebted to http://www.bumperart.com). But no, bumper stickers pose another danger: drivers who plaster their vehicles with the things are more prone to road rage than drivers who leave their car or truck unadorned.

Here is the link.

Be careful with tomatoes

Looks like the tomato scare is still ongoing. I never thought you could get salmonella through tomatoes.

The number of cases of sickness caused by tomatoes has risen in recent days; 383 people have been infected with a rare form of salmonella since April in 30 states and the District of Columbia, federal health officials said Wednesday.

Here is the link.

Cool Inventions

I have always tried to invent something. I'm sure we all have. I mean everyone wants to get rich.

Here are some cool inventions.


This one is my favorite. I need one of these to keep the wife off my back.

TOILET SEAT LIFTER Who left the Toilet Seat up?’ The PeaceMaker will end the battle of the toilet seat. Merely step on the pedal to activate the lifting mechanism. When finished, remove your foot from the pedal and the seat gently comes to a rest where it started.



Amazon even has it listed. See the Amazon listing.

Dumb celebrity quotes

Dumb Celebrity Quotes

Celebrities say the darndest things. I hope I have never sounded like this.

Here are some examples.

«I owe a lot to my parents, especially my mother and father.»
- Greg Norman, Golfer

«I think gay marriage is something that should be between a man and a woman»
- Arnold Schwarzenegger

«I want to rush for 1,000 or 1,500 yards, whichever comes first.»
- George Rogers, NFL New Orleans Saint RB, when asked about the upcoming season

Burger King Launches World's Most Expensive Hamburger

After six months in development, Burger King has launched "The Burger," a limited edition hamburger selling for $200.

Well I could make a burger and sell it for $201. What amazes me, is that 8 people have already purchased the burger. Must be nice to have that kind of money.

California Teenagers Face Prison for Hacking Into School Computers

When cheating on a test, most students either make out a cheat sheet or try to copy a classmate's paper. These two student went the extra mile. They hacked into the school computer and just changed their grades (allegedly).

Link Here.

AVERAGEA

AVERAGEA - This function returns the average of a sample. The value of a text is zero.

Syntax:

AVERAGEA(number1;number2; ...)

number1, number2, ... are numerical values or ranges.

Example:

Suppose we have given a test and we want to know the class average. One student did not take the test and you put a not on your grade sheet. However, you want to count this score as a zero. Refer to the screen shot.

=AVERAGEA(B2:B7) will return 62

Screen shot:

AVERAGE

AVERAGE - This function returns the average of a sample.

Syntax:

AVERAGE(number1;number2; ...)

number1, number2, ... are numerical values or ranges.

Example:

Suppose we have given a test and we want to know the class average. Refer to the screen shot.

=AVERAGE(B2:B7) will return 78.33

Screen shot:

AVEDEV

AVEDEV - This function returns the average of the absolute deviations of data points from their mean.

Syntax:

AVEDEV(number1;number2; ... ;number30)

number1, number2, ..., number30 are values or ranges that represent a sample.

Example:

We want to find the average of the absolute deviation of the following test scores. See the screen shot.

=AVEDEV(B2:B7) will return 9.78

Screen shot:

ATAN2

ATAN2 - This function return the inverse tangent of the specified x and y coordinates. This function gives the angle between the line passing through some point and the origin with the x-axis. The value that is returned is in radians.

Syntax:
ATAN2(number_x;number_y)

number_x - value of the x-coordinate
number_y - value of the y-coordinate

Example:
Suppose we have the point (10,20). What is the angle between the line passing through the given point and the origin with the x-axis.

=ATAN2(10,20) will return 1.10714872

Screen shot:

ASC

ASC - This function converts full-width to half-width ASCII and katakana characters. It returns a text string.

For a detailed explanation see this link.

Interested in programming

Microsoft has made Visual Studio available for free. You can download the express edition for free. I you do not want the entire edition, you can download which ever programming language for free. They have Visual Basic, Visual C++, Visual C#, and Visual Web Developer. You can also download SQL Server 2005 Express edition for free. You can also access video tutorials for each.

Here is the link

Create a Word Puzzle

You can create a word puzzle using google docs.



Here is the link

Google Doc's error message

I thought this was quite humorous.

Scientists Find Microbes That Eat Garbage, Excrete Crude Oil

Man, I can't wait for this. The gas prices are brutal these days. I'm sure they will still find a way to raise the gas prices. But man wouldn't you like to see those oil companies faces if this takes off?

Here is the link

Robot Girlfriend for Lonely Men

Guys, are you lonely. Well look now further. The japanese have come out with a 15 inch tall robot.

The robot, named "EMA," which stands for Eternal Maiden Actualization, is designed to pucker up for nearby human heads, entering "love mode" using a series of infrared sensors powered by battery.

Here's the link

Firefox 3

I have downloaded Firefox 3. I am really enjoying it. I think I am going to have to get used to the address bar. other than that everything is working fine. I've had no problems. What are your thoughts?

Lady's be careful

A Los Angeles woman claims she was injured by her Victoria's Secret thong, prompting her to sue the underwear manufacturer.

Lady's, please be careful if you wear thongs. They are very dangerous. I wonder what kind of warning label will be put on the thong now. I guess the bigger question, where will they put it?

Link to story

IE sends Firefox cake

The microsoft internet explorer team sent them firefox team a cake to congratulate them on Firefox 3 release. If you remember, they did the same when Firefox 2 was released.

Is Hell Exothermic or Endothermic?

Is Hell Exothermic or Endothermic?

I don't think I would like to take a test with only one question. What if you studied everything in the book but the material the question was related too? Well, I guess you could BS your through it like this guy. I have a suspicion this may be fake. But you never know. It amazes me what goes on in the world sometimes.

Funny Math

Funny math test

Here is a collection of student's math papers with some funny answers. I wonder if they got any credit for imagination. Probably not.

How to get rid of spiders?

I have lived at my current resident for about 2 years now. Everyday we see spiders. The neighbors have trouble with as well. I don't think there has been a day when I haven't killed a spider in the house. Actually one got in the bed with me one night, because I had a bite on my leg the next morning. I itched really bad.

Does anyone know how to get rid of spiders or how to keep them from coming in the house?

Yankee or Dixie Quiz

Yankee or Dixie Quiz

What percent Yankee or Dixie are you? I scored 93% Dixie.

Mr. We Trust

In God We Trust

An Illinois man changes his name to "In God We Trust". I wonder if the school system he works for will try to fire him?

Sick'em Boy

Man sicks python on police
Apparently 21 year old Victor Rodriguez apparently was threatening his girlfriend with a python. When police showed up, he tried to sick the snake on them. Of course, he was arrested.

This is not an actual picture of the python.

Firefox 3

Today is the day to download Firefox 3. Let's help get the record.

New Math

I like this video. Want to learn how to subtract? After watching this video, you will be an expert.

Happy Fathers Day

Happy father's day to all the dads out there. Hope everyone has a good one.

AREAS

AREAS - This function returns the number of individual ranges that belong to a multiple range. A range can consist of contiguous cells or a single cell.

Syntax:

AREAS(Reference)

Reference - Represents the reference to a cell or cell range.

Example:

=AREAS(A1:B3;F2:G5;J3) will return 3

Screen Shot:

ARABIC

ARABIC - This function calculates the value of a Roman number.

Syntax:

ARABIC(text)

text - represents the text for the roman number. The value must be between 0 and 3999.

Example:

Ever see those Roman numbers at the end of T.V. shows. Well now you can put them into a spreadsheet and see what number they represent.

=ARABIC("MMVIII") will return 2008
=ARABIC("MCMLXX") will return 1970 (year I was born)

Note: The Roman numeral must be in "".

Screen Shot:

Charging by the Byte??

Internet providers are talking about allowing only so many gigabytes of internet use. Once you go over this limit, your will be charged $1 per gigabyte. What are things coming to? I guess the internet providers have taken some lessons form the wonderful oil companies. They know we need and they are going to try and milk use for every penny they can.

Read the story here.

Mozilla Firefox Guinness World Record

Let's help make it a world record. See Download Day 2008

Sounds like a good deal, right? All you have to do is get Firefox 3 during Download Day to help set the record for most software downloads in 24 hours - it’s that easy. We're not asking you to swallow a sword or to balance 30 spoons on your face, although that would be kind of awesome.

The official date for the launch of Firefox 3 is June 17, 2008. Join our community and this effort by pledging today.

AND

AND - Returns TRUE if all arguments are TRUE. If one of the elements is FALSE, this function returns the FALSE value. The arguments are either logical expressions themselves that return logical values, or arrays containing logical values.


Syntax:

AND(Logical value 1; Logical value 2 ...Logical value 30)

Logical value 1; Logical value 2 ...Logical value 30 are conditions to be checked.

Example:

=AND(2<3;5>=4;11+10=21) will return TRUE

=AND(2<3;5>=4;11+10=30) will return FALSE


Screen Shot:

AMORLINC

AMORLINC - This function calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.

Syntax:

AMORLINC(Cost;Date purchased;First period;Salvage;Period;Rate;Basis)

Cost: the acquisition costs.

Date purchased: the date of acquisition.

First period: the end date of the first settlement period.

Salvage: The salvage value of the capital asset at the end of the depreciable life.

Period: the settlement period to be considered.

Rate: the rate of depreciation.

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

The cost is 2000. What is the depreciation on the first period for an asset that was acquired on September 22, 2007, where the end of the first period is December 26, 2007. The salvage value is 300, the depreciation rate is 12 percent and the actual number of days in the months and years are used.

=AMORLINC(2000;"9.22.2007";"12.26.2007";300;1;0.12;1) will return 553


Screen Shot:

AMORDEGRC

AMORDEGRC - this function calculates the amount of depreciation for a settlement period as degressive amortization.

Syntax:

AMORDEGRC(Cost;Date purchased;First period;Salvage;Period;Rate;Basis)

Cost: the acquisition costs.

Date purchased: the date of acquisition.

First period: the end date of the first settlement period.

Salvage: The salvage value of the capital asset at the end of the depreciable life.

Period: the settlement period to be considered.

Rate: the rate of depreciation.

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

The cost is 2000. What is the depreciation on the first period for an asset that was acquired on September 22, 2007, where the end of the first period is December 26, 2007. The salvage value is 300, the depreciation rate is 12 percent and the actual number of days in the months and years are used.

=AMORDEGRC(2000;"9.22.2007";"12.26.2007";300;1;0.12;1) will return 553


Screen Shot:

ADDRESS

ADDRESS - this function returns a cell address (reference) as text, according to the specified row and column numbers. You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (for example, A1) or in a mixed form (for example, A$1 or $A1). You can also specify the name of the sheet.

Syntax:

ADDRESS(row; column; abs;sheet)

row represents the row number for the cell reference

column represents the column number for the cell reference (the number, not the letter)

abs determines the type of reference:

1: absolute ($A$1)

2: row reference type is absolute; column reference is relative (A$1)

3: row (relative); column (absolute) ($A1)

4: relative (A1)

sheet represents the name of the sheet. It must be placed in double quotes.

Example:

=ADDRESS(10;40;1;"Sheet2") will return Sheet2.$AN$10


Screen shot:

Graphing Software

I have looked all over the internet for graphing software. I finally found a great graphing program that is free. It does a great job. Give it a try. Take a look at the link and the right side of the page for graphing software.

Spreadsheets

I have added some spreadsheet files you can download. Look under links on the right hand side. The spreadsheet files are under the links "Spreadsheet Files" and "Spreadsheet Function Files" Hope you enjoy them. I will be posting more soon.

Challenge Problem

Let's take a break from functions for a moment. Below is a challenge problem. Let's see who can get the correct answer. I will post the solution and answer in 1 to 2 weeks. Good luck.

ACOSH, ASINH, ATANH

ACOSH - Returns the inverse hyperbolic cosine of a number.
ASINH - Returns the inverse hyperbolic sine of a number.
ATANH - Returns the inverse hyperbolic tangent of a number.

Syntax:

ACOSH(number)
ASINH(number)
ATANH(number)

number represent the cosh, sinh, or tanh of a number.

The number you are taking the inverse hyperbolic cosine of must be greater than or equal to 1.
The number you are taking the inverse hyperbolic tangent of must be greater than -1 and less than 1.

Here is a link explaining the hyperbolic functions.
http://en.wikipedia.org/wiki/Hyperbolic_function

Examples:

=ACOSH(5) will return 2.29243167
=ASINH(-2.2) will return -1.52966050
=ACOSH(.35) will return .36544375


Screen Shot of ACOSH():

ACOS, ASIN, ATAN

arccosine - The inverse function of cosine.
arcsine - The inverse function of sine.
arctangent - The inverse function of tangent.

Syntax:

ACOS(number)
ASIN(number)
ATAN(number)

number represents the cosine of an angle.

Example:



Now let's use calc to evaluate the arccosine of 3/5, arcsine of 4/5, and arctangent of 4/3.

=ACOS(3/5) will return .92729522
=ASIN(4/5) will return .92729522
=ATAN(4/3) will return .92729522

Note: The ACOS, ASIN, ATAN functions return the angle in radian measure. We will talk about getting an answer is degrees later with the DEGREE function.

Screen Shot of ACOS():

ACCRINTM (Calculates the accrued interest of a security in the case of one-off payment at the settlement date)

ACCRINTM - Calculates the accrued interest of a security in the case of one=off payment at the settlement date.


Syntax:

ACCRINTM(Issue;Settlement;Rate;Par;Basis)

Issue: issue date of the security.

Settlement: date at which the interest accrued up until then is to be calculated.

Rate: annual nominal rate of interest (coupon interest rate)

Par: par value of the security.

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

A security is issued on February 4, 2007. The maturity date is set for September 22, 2007. The Rate is 9% and Par is 1000 currency units. The basis of the daily/annual calculation is the daily balance (3). How much interest has accrued?

=ACCRINTM("2.4.2007"; "9.22.2007"; .09; 1000; 3) returns 56.71232877.

Note: The month, day, and year are separated by a period. Also the entire date must be in "".


Screen Shot:

ACCRINT (Accrued interest)

ACCRINT - Returns the accrued interest for a security that pays periodic interest.

Syntax:

ACCRINT(Issue;First Interest;Settlement;Rate;Par;Frequency;Basis)

Issue: issue date of the security.

First interest: first interest date of the security.

Settlement: date at which the interest accrued up until then is to be calculated.

Rate: annual nominal rate of interest (coupon interest rate)

Par: par value of the security.

Frequency: number of interest payments per year (1, 2 or 4).

• Yearly = 1
• Semiannually = 2
• Quarterly = 4

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

A security is issued on January 3, 2007. First interest is set for November 12, 2007. The settlement date is May 16, 2007. The Rate is 11% and Par is 1000 currency units. Interest is paid quarterly. The basis is the US method (0). How much interest has accrued?

=ACCRINT("1.3.2007"; "11.12.2007"; "5.16.2007"; 0.11; 1000; 4; 0) returns 40.63888889

Note: The month, day, and year are separated by a period. Also the entire date must be in "".


Screen Shot:

abs (Absolute Value)

Absolute Value - Represents the distance from one point to another on the number line. Absolute value is always returns a positive number.

Syntax:

ABS(number)

number represents what you are taking the absolute value of.

Examples:

ABS(-35) will return 35

ABS(23) will return 23

ABS(0) will return 0

Screen Shot: