Applications :: IWork Numbers - Formula With Category

Aug 14, 2010

I have a list of expenses and there are columns such as "Description, Cost" the usual, but I also made one named "Type" that is populated with either "Business, Personal," or "Fixed Expenditures".

I would like, then, to make another table that links to the first with three rows. Each one adds the total cost of Business, Personal, and Fixed Expenditures. How can I accomplish this?

I want to divide the expenses into expenses types and create a sum for each type.

Basically, it categorizes the expenses and puts them in three different totals: one for each "Type" of expense.

View 3 Replies


ADVERTISEMENT

Applications :: Unable To Use Numbers Formula

Mar 14, 2009

I'm trying to create a template for legal billing. The only thing I'm really having a problem with is the formula that multiplies time by hourly rate. The time spent cells are formatted to show it as 4h 5m ... and that totals perfectly with the SUM formula. When I multiply it with a rate cell formatted to currency the math is fine, but the format stays as 00h 00m ... even when I format that cell to currency.

View 5 Replies View Related

Applications :: Finding Mac Numbers Formula

May 27, 2009

I want to set up a cell that has a number in it. That number is to decrease by one every seven days is there a formula that I can use to do this automatically

View 2 Replies View Related

Applications :: Using Excel Formula In Numbers

Feb 22, 2010

I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.

In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another.

I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.

View 2 Replies View Related

Applications :: Numbers - Formula For Scheduling A Timetable

Oct 14, 2010

I am studying, there is a weekly timetable made of 20 individual classes, each on 4 times a week. I would like to know how to make a spreadsheet so I can manually input all these classes and have it return a non conflicting pattern. By that I mean that I want a personal timetable that will let me visit each class at least once a week.

View 1 Replies View Related

Applications :: Excel To Numbers - Fx Formula Not Compatible

Jan 25, 2010

I have recently run a 13 page excel spread sheet for a budget on Windows and on transferring it to Numbers on my new mac, one of the formulas is not compatable. this is what I do. There is a balance figure on each of pages 2 to 13 which are then required to be transferred as a total figure in one of the columns on page 1.

This was the formula on windows: =SUM(xmas:Savings!F2)

View 4 Replies View Related

Applications :: Numbers - Formula To Calculate Pay Per Hour / Day

Mar 23, 2010

I'm an independent contractor and keep track of my hours worked & amount paid for the year in numbers, and thus far its working Great! However, I'm attempting to figure out how much my "pay per hour, per day" is, and need am wondering if there is an easier way to do this.

My spreadsheet is setup like the following:
Rows = Days worked
Column F = Time worked
Column G = Amount paid.

So to figure out how much I made "per hour per day", I simply take Column G divided by Column F for each day. However, I'm currently manually entering this script into each row, and given that I worked over 200 days last year(i.e. I manually enter in row 1 =SUM(G1)/(F1); row 2 =SUM(G2)/(F2), etc.

Is there an easier way to do this? Is there a way to sequentially apply scripts, so instead of manually entering G2/F2, it will automatically apply the =Sum G / F's of that row? I'm on numbers 08

View 3 Replies View Related

Applications :: Numbers - Formula Not Let To Select Cells - Only Whole Column

Oct 17, 2009

I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)

However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).

View 2 Replies View Related

Applications :: MS Word, Exel, IWork Pages, IWork Numbers Not Saving/Hanging On Save

Nov 1, 2009

I have a:
Macbook Pro running Mac OSX 10.5.8
(Office 2008) Word, Exel, PowerPoint, (Iwork 2009) Numbers, Pages will not save:.
I tossed the Word Plist file and that did not work.
I have run Virus Barrier X5 and found a about 10 files with Virus 'W97M/Pinky.B' "Quarantened" them and still have the problem.

The problem started -- I think -- when I was doing heavy editing between Numbers and Word. But I don't think it is related (though who knows at this point). Without these programs I'm rendered pretty useless.

View 7 Replies View Related

Numbers :: Formula To Budget On A Per Pay Period

May 3, 2010

I am creating a new budget sheet, and am trying to automate it as much as possible. I get paid bi-weekly, and I like to budget on a per pay period case rather than month to month. What this means is that on certain budgets I have one set of bills due, on another I'll have a different set of bills due.

View 5 Replies View Related

Applications :: Merge Cells IWork 09 Numbers?

Oct 21, 2010

Is there a keyboard shortcut to merge selected cells?
Numbers '09, version 2.0.3 (332)

View 1 Replies View Related

Applications :: Unable To Use IWork Numbers Printing?

Nov 30, 2009

I made a task list in numbers. The font on the list is Helvetica 12. Now, the paper I am printing it on is 5 x 8.5 that fits in my notebook.

When I print the fonts that come out are very small. I have tried everything but nothing works. How come I don't get a what you see is what you get page?

View 4 Replies View Related

Hardware :: USB Transfer Rates - Formula For Real World Numbers

Oct 30, 2009

I have a "My book Pro" 250 GB external hard drive spinning at 7200 rpm. This thing is dog slow. It takes about 5 to 10 seconds to copy about 2 megabytes. I have another drive that copies about 160 megabytes in about 5 seconds. I called Western Digital (the maker of the "My Book Pro") and they said that USB 2.0 transfer rates are about 2 MB a second! That is not true but he insisted. My question to you all is how can i win this argument with them? Do you know a formula that would give me real world numbers. In other words how to translate 480 megabits (the USB 2.0 transfer spec) into megabytes? Ive searched the net and cant find anything. Its messed up cause both drives have basically the same specs. Ive even tried reformatting to every possibility, ive switched cables from the fast drive to the slow drive. Nothings working. Im gonna call WD back tomorrow but i wanted a way to talk about what could honestly be expected from USB 2.0. I just cant believe that USB 2.0 tops out at 2MB a second. And to top it all off, todays call ended up with me getting disconnected so i called back and guess what, they were closed...that guys a DOUCHE. I really cant put my faith into Western Digital after this. Are there drives that are geared more towards professionals seeking performance and reliability?

View 5 Replies View Related

Applications :: IWork 09 Numbers Supports Right To Left Languages

Jan 10, 2009

I just purchased iWork 09 and I'm using a language that writes from right to left. I notice that Numbers, after I deselect the cell switches the writing from right to left to the opposite. Does this mean Numbers doesn't support RTL languages??? Pages seems to work fine but Numbers doesn't

View 1 Replies View Related

Applications :: IWork / Numbers - Export Data Into Document?

Feb 2, 2010

We are currently using Numbers Spreadsheets to keep track of customer's payments in our office. We want to be able to export this information into a document which can be personalized based on their name and balance left on their account.

View 1 Replies View Related

Applications :: IWork 09 Have An Autosave Feature In Pages - Numbers And Keynote?

Jan 19, 2009

Does iWork 09 have an Autosave feature in Pages, Numbers and Keynote, as so many wanted in iWork '08?

Also, does anyone know if the equation editor can work with MS Office 2004's equation editor, or does it only work with the one that you have to buy off another website (can't remember the name of it)?

View 5 Replies View Related

Software :: Can Manually Record Debit And Credit Transactions By Description, Category And Sub-category

Aug 10, 2009

I currently use Quicken for Mac 2007 for my budget and finance.fonts are far too small for me to see clearly and cannot be changed. My budget and finance requirements are reasonably straightforward1. Create income and expenditure categories and sub-categories 2. Create 3 accounts (cheque, savings, credit) in which I can manually record debit and credit transactions by description, category and sub-category 3. Create annual budgets with specified amounts each month (not average amounts) for categories and sub-categories

View 10 Replies View Related

Software :: Can I Get Numbers Without Whole Iwork?

Jan 13, 2009

i purchased iwork 08. do i need to repurchase for 09 or is there update. has anyone used numbers 09 and is there a reason to update? can i get numbers without whole iwork?

View 3 Replies View Related

OS X :: How To Open Numbers Docs Without Having IWork?

Dec 3, 2010

I received an email from work containing an attachment that is in numbers format (.numbers), however, I don't have iWork on my Mac.

I need to be able to view this document. Is there any way I can view it without having iWork?

View 4 Replies View Related

OS X V10.6 Snow Leopard :: Crashing IWork Apps - Cannot Get Pages, Numbers, ITunes To Run

Apr 9, 2012

I am running 10.6.8 on my iMac, I cannot get Pages, Numbers, iTunes to run for the last couple days. Also Word crashes as soon as I hit print.

Info:
iMac

View 3 Replies View Related

Applications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers

Jul 17, 2010

I've been ripping my hair out trying to find the answer to this.

In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.

For example:

Column A - 1 - 5

Column B - (value in Column A * 5)

I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.

The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"

View 1 Replies View Related

Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?

Mar 24, 2009

See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.

like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.

View 3 Replies View Related

Applications :: Hold Off On Purchasing IWork Apps (iWork Related)

Jan 6, 2011

props to Stuipdboy1000 on the heads up
under Quick Links
you can see iWork '11

Quote: Originally Posted by Stuipdboy1000

It's an official photo from the App Store page on Apple's website, not from the store itself. seems like Apple might have an iWork 11 release soon Apple edited the picture on the website to take out the '11 but it was there earlier

View 19 Replies View Related

Applications :: IWork 08 Doesn't Work The IPad But IWork 09 Soon To Be Updated - Isn't It?

May 29, 2010

I need to update iWork on my Mac cos iWork 08 docs don't work on my new iPad. But iWork 09 is about 18 months old now so surely will be updated soon. Would anyone who is learned in the product cycle of Mac apps care to hazard an educated guess on an update?

View 2 Replies View Related

Applications :: Difference Between IWork And IWork Family Pack?

Apr 1, 2009

Indeed, is there a difference? I notice that Family costs more than the other one, but I can't make out what difference there is in the description.

View 7 Replies View Related

Applications :: Excel 2008 Date Formula ?

Feb 28, 2009

I have a very limited knowledge of Excel, but generally find that I can figure things out eventually. However, this time, I just can't seem to tweek it so the result is what I want.

I have a spreadsheet for tracking parts ordered, and simply need to display how many days a part has been on order. I have a column for date ordered, and one for date received. Is there a way to program the formula to tell me the days that a part has been on order without displaying today's date in the spreadsheet (leaving it blank), and still be able to enter the date that it does arrive for our records?

View 4 Replies View Related

Applications :: Should Buy Iwork Or Update Of Iwork 08 During Macworld 09?

Nov 3, 2008

Is there any talk of an update of iwork '08 during Macworld '09? I am a switcher to Mac as of last month and I really like pages instead of word. I've been using a trial version and I'm going to buy it, but I was wondering if I should stick it out by using google docs in the event that they release iwork '09. By the way, in case any admins are reading this post, why don't they include Apple software in the Buyers Guide?

View 8 Replies View Related

Applications :: Save As IWork 08 File In IWork 09?

Jan 12, 2009

Why is save as an iWork 08 file an option in the new iWork 09 programs? Does iWork 08 use a different extension that cannot open iWork 09 documents?

View 5 Replies View Related

Applications :: Install IWork After Trial With IWork Box?

Feb 8, 2009

So I used the iWork '09 trial for 30 days now and now I have a box version and I want to simply use the buy function from the trial to upgrade to the full non-trial version. It has: Quote: If you've purchased an iWork '09 box, you'll find the serial number on the Installing iWork '09 booklet. There's only one problem, there's no serial number on the booklet! How do I install using the buy function or do I have to install the full iWork suite again on my computer? Seems kind of silly. If so, do I need to then uninstalling one of my versions of iWork '09? And if so, which one? How do I tell the difference at that point?

Some of you might be wondering and about to comment on the fact that I should have just bought the online version and saved the hassle. The reason why I bought the box is because I could get it for $39 at my girlfriend's campus computer store.

View 6 Replies View Related

Applications :: ITunes Library Category Question

Nov 15, 2009

What is the number to the right of my iTunes Podcast library category?

I also have a number to the right of my applications category and figured it is the number of updates available. If this also applies to my subscribed Podcasts, then I have no idea which podcasts have updates available. How do I find out?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved