excel formulae

i'm creating invoices from cost sheets. in order to hide the 'true' mark up (profit) i have to inflate the labour (time taken) however how more oftenthan not i end up with a figure that is not divisible by a time unit such as, 3 hours, or 3.25 hours, 4.75 hous ......must be quarter of an hour increases etc. what formulae might one create, to make a monatary figure relate to a time figure in .25 units (15 minutes) example a sum of £88.23 divided by labour rate of £27.00 = 3.26666666 ideally this time figure should be 3.25 hours or, 3.5 hours.... ideas? regards Dean

How to convert a ($200) cell to a written amount(Two hundred doll

Is there way to convert dollar amount in a cell to a written amount like $250.00 to two hundred and fifty dollars and 00/00 cents.

fill a color to a row

Hi, I want to check a column (lets say H) if there is a 1 value i want excel to color the row. lets say there is a 1 on H6, I want to fill a color to row 6. It can be full coloring or if i can i might like to range it to A6:J6 thanx in advance

rows & columns height & width

Hello, Is there a way of forcing the row height and column width to be equal , and to remain equal, so that all cells are square ? Thanks KK

multiple files open upon startup

Every Time when I open Excel 2007 after updating from 2003 - multiple files (140 to be exact) open before I can even select open file to get the one I want. I went online and download updates today, now it opens 243 files. I have closed each one, tried to close group (it won't let me), deleted files all to no avail. How can I stop files from opening automatically upon starting Excel? It's very frustrating HELP PLEASE I have tried getting ahold of microsoft directly and can't get any help here either. I'm stuck without help. Can anyone please help me?????

SORTING HELP!

If I sort my table alphanumerically by one of the columns in the middle, how to I make sure all the info in their respective rows follows them? I need to alphabetize my document by information in the 5th row, but when I do that, the rest of the information gets all out of order, how do I get it to sort that way without loosing the corresponding info in the rows? Thanks

EXCEL files and Windows - - an open and shut case?

Hi I posted this on the Win 7 technet forum and was told to post it here. so, --- I’m using windows 7 64bit and Office 2007 Please can someone explain how I can open 2 Excel files in separate Windows? Currently when you open 2 files they both open in the same window but different tabs. I have searched around and found the following answers for XP and Vista “Open Windows Explorer Select "Tools" Select "Folder Options" Select the "File Types" Tab Scroll down to find and select the XLS extension Click the "Advanced" Button Select the "Open" action from the

Text To Date Conversion

Hi I run Excel 2000 I download information from a mainframe into Excel. In cell F5 the data looks like this: 19.11.2007 This is formatted as text and is left aligned. When I try to reformat it to a date (19/11/2007) it does not change. I would like to have a formula in cell N5 that changes the original data to a datevalue. (eg: 19/11/2007) Thanks

looking up a value only if it returns a value in another list

I have two data tables in Excel 2007. Table A holds a bill of materials with parent and child parts laid out suitable for use with vlookup. Table B holds a selected list of raw materials which are child parts. I want to lookup a parent part from a cell and search for one of its child parts in table A if the result of the search matches one of the raw materials in table B. I can do simple vlookups but this is outside my knowledge. Can anyone please point me in the right direction? Thanks -- Richard

EXCEL - NEW PAGE

HOW DO I INSERT AN EXTRA PAGE IN EXCEL?. THERE ARE NO BUTTONS ON THE TOOL BAR TO DO THIS. I HAVE WINDOWS 7 WHICH IS NEW. ALL THE DATA FROM MY OLD MACHINE HAS BEEN TRANSFERRED TO THIS NEW MACHINE. I DO NOT HAVE 'FILE,EDIT,VIEW ETC' ACROSS THE TOP OF THE PAGE. PLEASE HELP

Conditional format

Dear All I, create conditional format related to one column data range showing the staff ID, I want when I enter the staff ID if it is available in my data range, it will apply my conditional format, so my formula it is working for ID Like 1070, or 1470 But when I inter ID like B1101 It is not working, my formula in conditional format like this =VLOOKUP(A1,$K$2:$K$65,1,FALSE) > Please Help Thanks

Organizing rating scale information into a narrative paragraph

I have teachers complete a teacher rating scale with four colums. The first 3 columns are: above average, average, below average. The fourth column is a descriptor for a behavior (completing homework). There are about 20 rows of behaviors. Question: I would like for all behaviors rated 'below average' to automatically move from the rating scale to a narrative paragraph such as: The teacher rated the student 'below average' in the following behaviors: completing homework, [then all other behaviors rated below average followed with a comma and the narrative paragraph ending in

Formula in a coloum

I have this code UltimaRiga = Range("A65356").End(xlUp).Row For i = 3 To UltimaRiga Range("G" & i).Value = (Range("D" & i).Value - Range("I" & i).Value) Range("G" & i).NumberFormat = "0_ ;[Red]-0 " Next i but I think is better (faster) without loop, is it possible? Thanks in advance!

How can I change worksheet direction from right to left

I want to change the direction of the work sheet in Excel 2007 from left to right and vice versa

copying/sorting data with blank spaces in between?

I have a membership list I need to update for a club. I have used Excel very little. I have been trying some different things to see if this will work before I get the data file (which I will back up before hand) In 3 columns to the right it has year dates in them. I need to change them. depending on the person, the first column would all be the same changed from 2007 to 2008. The problem is, there are spaces between some of those particular columns. (see below) when I try to highlight them individually and past, say 2008, it will not allow me. Is their a way to do this? It says I

Floating Column

Hi, I'm making a speadsheet of my shifts over the next year. I've put the days at the top but would like the column to scroll down with the page. How do you do this? Thanks

printing excel 2003 spread sheet

i need to know how i can print my spread sheet it has several rows and colums and i was all the information to appear as it does on the spread sheet with the borders incuded how do i do this. i tried print preview and it shows the information on two pages and with no borders

Reverse naming of file

Hi, I'm copying data relating to an engineered part into a sheet. The format is constant and the name of the client and part appear in specified cells. Is it possible now to rename the xls file as (constant+ partname)? I mean automatically, not cutting and pasting. thanks

Keys to access the tabs and commands on the screen

The problem I’ve got is that I activated them (don't know even how) and it appear on my ribbon the keys not just when I press ALT but also (end this is the main problem) when I press the button ?. How can I deactivated all those and be free to work with the keyboard without activating the ribbon pressing some button? Cheers,

could someone write me a VB code? thanks

hi, i have 2 cells, V17 and X25, these cells get values in them depending on what is entered into on other cells, no data is directly entered into these cells. Is it possible to have the values that appear in these cells captured and put into a list on a sheet called 'graphs'? below is what the 'graphs' sheet would look like. A B 2 7 3 6 1 3 4 9 5 3 -- thanks for your help

Database fields in Excel?

I have an order sheet system set up in Word which uses merge fields in tables to fill in store names, dates, etc. The "database" linked to the tables is an Excel sheet which I update manually each week. On every page, below each table, is an OLE spreadsheet from Excel which has the actual items on the order form. I'm wondering if I can "eliminate the middle man" and just put the merge fields into the OLE sheet. Is it possible to insert merge fields into an Excel sheet and link one sheet to another?

How do I delete a "function" from a cell in MS Excel?

When I type a number into a cell, and move on, the number inside the cell turns to "###". I just want the number to appear in the cell without any functions.

Excel View

When I am using Excel I can not see my fill colors in Normal View. I can hit print preview and see the fill colors and the doc will print correctly, however I would like to see my fill colors as I am creating my spreadsheet. How do I get the program to do this?

Workbook back up

Hi, Is there a way to have excel create a backup file saved somewhere each time the workbook is either opened or closed? I know there is the auto recover but it doesn't really save a back up file that I could open when ever I need to. Thanks,

Column widths change with each new import from Access 2007

I am using an invoice template I designed that pulls records from an Access 2007 query. The number of records imported changes each time the template is used for a new workbook. I've managed at last to get the results I want from the import, but the column widths for the data changes each time to widths other than what I'd saved them as. It is totally screwing up the formatting I want for the worksheet. How can I lock the widths of these columns at what I want them, regardless of what data is imported?

Save as Template

I have a workbook which I would like to save as a template but can't find how to do this in Excel 2007. Can anyone help, please?

incremental counting?????

I am workinging on an .xls spreadsheet with this numbering scheme in Column A. 1 1.1 1.1.1 1.1.1.1 1.1.1.2 1.1.1.3 1.1.1.4 1.1.1.5 1.1.1.6 1.1.1.7 1.1.1.8 1.1.1.9 1.1.1.10 1.1.1.11 how do I get the fourth node to increment on its own, i.e. 12,13,14, once I add data to the next cell over or column B.

Using the "if" function, the "and" function and the "or" function

I am not sure if or how to use all three in a formula. For example: =if(b2="red", and c3="blue", d6="green") if that makes sense at all.

MS Excel 2003 - Advanced Features Add-In

The Advanced Features Team is pleased to announce the release of the first version of their Add-In for MS Excel 2003. Part of this realease are the following functionalities: * Easy and powerful connection between MS Excel and MS Access * K-Means clustering algorythm * Additional User Defined Formulas * Deeper Query and Pivot Tables Manipulation Tools, including easy redirecting MS Olap cubes and Database Queries * Fast and Easy Worksheet Formatting and Management, including functions for Hiding and Grouping, changing worksheet visibility, get available workshee

sumif

I need to add the total in cell H6 if the following condition is met If H6<>0 and A6 contains the word "total" (where A6 can contain alpha and numbers) i.e. the formula must only find the total if a6 contains the word "total" and not if it simpy contains other figures or alpha is this possible? -- Barny

copy row to different tab

Creating a SS with 6 tabs(master,A,B,C,D,E) each having 5 columns(doc#,category,date,box,folder). "Category" can have 5 different values, A,B,C,D,E According to which value in 'category' is entered in master I want to copy the row and move it to corresponding tab. Can an IF statement do this? thanks, L.

in xcell, how do I select on 1 cell? my cursor selects multiples

While this problem doesn't always occur, it causes me problem when for some reason while working in a spreadsheet, it starts pickup up multiple cells whenever I move around with the cursor.

one code to do multiple things

hi, i have the code below which takes the value in cell U17 everytime it changes, and places it in column A on a sheet called graphs thereby forming a list down the sheet of all the values that appear in cell U17, for charting purposes. What i would like to do is to be able to duplicate this for different cells. ie have the cell values of W25 appear in a list in column K on the graphs sheet, and so on. this code was written for me by someone else as, could you please give me some code that will enable me to capture the values for two or three cells in sheet1 into the sheet cal

How to apply Macro on a same type of format but columns no. r chan

HI, First of all i 'd like to explain what problem i'm facing. See i've data in three Rows and three Columns. I've recorded macro & i applied the same macro in same formation. like three Rows & Three coloumns. But the question here is now i've Five Rows & Five coloums. Now if i apply the same macro here then it overrides the data over three rows and coloumns. Please let me know can i do apply the same macro because the formation is same only data is in more no. Looking forward to hearing form you. Thanks, Manmohan Singh

IF/ISBLANK formula

When using this formula =IF(ISBLANK(B2,"",VLOOKUP(B2,D2:E20,2,1)) I am getting the #N/A error or incorrect data if the value in cell B2 starts with a 0 eg 07934. Any suggestions as to fix this? Thanks

Constant required

Hi, I have two sheets 'cost' and 'materials' on which the constants are placed A cell on 'cost' has this formula =C9*materials!D37 I now need to copy this down any number of times, the first repeat reads =C10*materials!D38, whereas I want it to read =C10*materials!D37 I've tried this =C9*materials!$D37 but get =C10*materials!$D38 How do I keep the cells not increasing? thanks.

importing text as a URL

hi all, I need to import a csv file where every row has an URL such as .....,http://www.something.something,....,..... When I import it the URL is considered as text by Excel, i.e. no hyperlink is automatically created. How do I tell excel to create the hyperlink when importing? thanks

Sum of product

I am trying to find a formula to total a specific product from a list into another worksheet for totals. Can i use a LOOKUP formula to look for that specific product and give me totals for the year in another worksheet? Thanks;

help with inputting code

hi there, i have some code (below) that takes the value of cell U17 every time it changes and then lists it in a column on the 'graphs' sheet for charting purposes. i would like to duplicate this code for another cell W25 having it form a list on the 'graphs' sheet in column K, when i copied the code below then pasted it into VB and amended the values it came up with a compile error :( it must be something simple that i'm doing wrong, any ideas? Private Sub Worksheet_Calculate() Dim Dest As Range With Sheets("graphs") Set Dest = .Range("A" & Rows.Count).End

Delete worksheets in Office Excell 2007?

How can I delete worksheets in Office Excell 2007?

Sum and If

I am wanting to add numbers in Column B,d,f etc only if it equals the text in Column A,c,e etc -- Shirl, NZ

How does "Search For" By or Subject work?

(This is a question about how to use the Forum; not how to use Excel. I know it doesn't belong here. Please accept my apologies. I can't find any other place to ask it and the Contact link at the bottom of the page appears to be broken.) The Help for the Forum says that Search For searchs the By and Subject fields as well as the message bodies. I can't figure out how to search the By and Subject fields. For example, I entered my first post on 2/19/2010 in the Excel General Questions forum. My user id is "SVanDee". The Subject is "2007 Structured Reference auto-completion not w

Making actual projects with Excel 2007

I have read several books and so far have basic and general understanding of the mostly use features of Excel 2007. However, I am wondering if there are resources that can help me do actual projects. I learn quickly by doing practical stuff rather then reading a 1000 page book about features and why I should use a certain program. Were can I find tutorials on actual projects? Example: How to make a spread sheet for a grocery store. Any ideas or recommendation will be highly appreciated. Thanks everyone. Ai

how do i use the daye function to insert a serial number

how do i use the date function to insert a formula that inserts a serial number for a specific date

just need to display formulas nothing appears

I am a student and it says to display the cell formulas in the worksheet. I have tried EVERYTHING and can't figure it out??? Please help

Excel 2007 won't print spreadsheet

New HP computer with Win 7 and MS Office 2007. Printer is Dell V505, and I have installed correct printer driver for Win 7 and the Dell prints everything OK until I tried Excel 2007 spreadsheet which the Dell will not print. I get error note (no message) in Start/Control Panel/Printers. Is a special printer setup needed for Excel 2007? Hope you can help. Thanks...

Where is Excel 2007 on my computer?

I use Excel and Word 2003. My new computer -- new about six months ago -- came with MS Office 2007 pre-installed and I activated it. However, I never use the 2007 tools -- Word, Excel, etc. -- I find them too confusing and the 2003 versions work for me. A friend sent me a database in xlsx format, or something like that. When I clicked on OPEN, it opened in Excel 2007. However, I can't find an Excel 2007 icon anywhere on my computer. I tried Start->All programs and looked in every folder -- no Excel 2007 icon. Used Windows Explorer and went to c:\Program Files -- nothing fo

find&press button

Hi everybody, i'm using excel 2007,when i press the find&select button it dosen't sow me the cell i'm looking for,it has been disabled,although when i look the rows one by one i can find it,how can i able the find&select. i'd appreciate if u'd let me know,cuz i'm in trouble here

HOW DO I CHANGE THE COLOR OF THE EXCEL SPLIT LINE

HOW DO I CHANGE THE COLOR OF THE EXCEL SPLIT LINE

How do I convert text to "proper text"?

I am trying to convert the text from all caps to Caps and lower case better known as proper text. I used the functions tab and then the formula auditing box and then select show formula. After that I am lost. Please help Thanks Sunny