Ray
You can identify changes when updating your spreadsheet by using conditional formatting. If you have a column/row with last weeks figures in and a column with this weeks figures in. Then choose this weeks cell, choose Format, Conditional formatting, choose Cell value is, not equal to,type last weeks cell ref. and in Format choose patterns and choose a colour. Copy formatting to other cells. These cells will automatically colour when value is different. As for email, pass.

Holli
To clarify option 1. You need to create a calculation column otherwise you have a circular calc.
Eg Say B1,B2,B3 had values 4,5,and 6 respectively, andC1,C2&C3 had values 7,8,&9. Suppose you want your answers in column D. Create a column elsewhere, it can be anywhere but we will use column E. You have existing control values here. I.e. E1 is 23, E2 is 40, and E3 is 12. We want to get the product of B*C but only if it is less than our control value. Therefore in our result cell D1 we type =IF(B1*C1<E1,B1*C1,E1). (I always think it helps to think of the first comma as meaning “Enter” and the second comma as meaning “otherwise Enter”) Copy the formula down to other cells. If you don’t want to see the calculation column (E) select it and go to Format, Column, Hide. If you just want blank or zero values look at simpler options.

Holli. After the last comma in function,ie answer when false, type the existing cell reference.
Or if you wish to leave blank you can enter 0 and in options choose not to show zero values.
Or enter "" in function. This will format cell as text, however, and may cause you difficulty if you intend performing any further calcs on that cell.

within an IF function, how can i leave the cell contents as is when condition is false?

I have a spreadsheet to which values for equipment levels on all of our sites are added weekly. Is there a way in which all changes can be automatically spotted and uploaded to an email?
Sorry if this sounds a little vague. The guy who built the document has now left and I would like to make it easier to spot the changes.

Thanks.

in A2 type '=A1*1.15'


>
< replied-to message removed by QT >

Edited by author 29-10-2009 08:22 PM
/m2267
Margaret, In cell A2 enter =A1*1.15. That will give you a 15% increase of the value in A1

how do I add a percentage to a figure e.g I have the net price of an item in A1. In A2 I want the cost of that item with 15% VAT added. every way I try to do this gives me a very incorrect number. I am using excel 2007.

say I have 40 items listed in Excel, how can I generate, say, 30 random groups of five items from the list. They could be numbers but I would prefer if possible to do it with text entries. Just to clarify, there would be 30 selections. each selection would consist of 5 items chosen at random from the list of 40.

I have created a Mail Merge document in Word using Excel database. I have got two date fields in my document. I'm able to format the first date field to my desire, but unable to do so for the second one. Is this a limitation of Mail merge or am I doing something wrong.

Please help.

Edited by author 11-10-2009 01:21 PM
/m2261
Jeanette, If I understand your requirement you have a series of coordinates in column A. You want to add a number to each of the cells in column A and place the result in column B. e.g A1 = 10, add 20, B1 = 30; A2 = 5 add 20, B2 = 25

If my example is correct then I would place the number I want to add in a separate cell away from the two columns e.g. C1 then in B1 place the following formula

'A1 + $C$1' then pull down the fill handle in the bottom right corner of B1 to copy the formula down all rows

Now you can change the value of C1 if you wish and recalculate the spreadsheet without having the change any other formulae

/m2261
Jeanette,
If I've got this right - you want to add the number in column 1 to itself and show the result in column 2?
The easiet way to do this is to put this '=SUM(A2+A2)' in column 2 and then use the fill handle to pull down the sum to the end of your data.
HTH
Mark

I want to do something that seems very simple, but I can't work out how. I have a column with different numbers in each cell (actually coordinates). I want to create a second column by adding the same number to each cell in the first column. I can create a function to do this, but only by typing it in each cell in the second column - and I have hundreds to do. I thought of adding an intermediate column filled with the number to be added, then doing autosum across each row, created the results column - still doing it row by row, but much quicker. This works at first but as soon as you have done two rows, autosum defaults to adding the numbers in the results column, rather than adding across the row. There is probably a really simple solution to automating this, but I can't see it.

any idea how i can move the top axis (column header )on a spreadsheet from being 1,2,3 etc to A,B,C etc.

I know normally the cells are A1.B2, etc but somehow i've got a corrupted Spreadsheet with numbers both on column & row headers.

Help !