General

replace a negative result with a zero?
I have my formula entered but need it to return a zero if the result is negative. Any help is greatly appreciated. -- Pam ... 19 Apr 2010 12:37

2007 excel autofilter back to 2003 autofilter?
Is there anyway to get the 2003 autofilter functionality to work in excel 2007? ... 19 Apr 2010 15:43

Using Conditional Formatting to Pass/Fail
I want to use conditional formatting to return a pass fail number based on a numeric value. However the number has to fall between 2 values. i.e A product will pass if the numeric value it achieves is between 2 and 8 but if the value is less than 2 or greater than 8 it will fail. I can't seem to get the if stat... 19 Apr 2010 12:37

Excel cell value equals selected text from Word
Is it possible to bookmark or link a piece of text in Microsoft Word eg. a title in the word document is 'West Belfast Profile' In Excel, I would like to make a cell value equal to the text from Word. Basically cell A5 in excel equals 'West' from the title 'West Belfast Profile' in Word. If the user changes the... 19 Apr 2010 11:34

why are my column headers numbers instead of letters?
It seems like overnight my spreadsheets changed from having letters as column headers to having numbers. I'm sure it's something I've done wrong...can anyone help me? ... 19 Apr 2010 11:34

Excel formula
Hi all, looking for help with a formula, I have column G which is money recieved, ideally this should be €40 in each cell, however sometimes it is more or less, so i have column H which is the difference between money recieved and €40, eg if €35 recieved, shows -€5 if 45 recieved shows €5. I had =G26-40 howeve... 19 Apr 2010 11:34

Script to insert Row
How would I write a scrtip to insert a row under the number in A that holds a "NS" or "MT"? I would also like it to copy the row that has "NS" or "MT" in it and paste it in the row that was inserted underneith. When it copies the row it will copy the whole row except what is in A. Example Before A ... 19 Apr 2010 10:32

can quadratic equations be solved in excel
... 21 Apr 2010 17:46

How to retrieve the value within string?
There is a string in cell A1, such as ......... .... (3.25%) I would like to retrieve the text inside (), which should return 3.25% in cell B1. Does anyone have any suggestions on how to retrieve the text within string? Thanks in advance for any suggestions Eric ... 20 Apr 2010 08:16

IFBLANK
I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated boxes that are blank but will show dates once data has been input. eg: A B C D 34 NAME DATE FUTUREDATE 35 John 15/03/10 =C35+(7*6) 36 D36 Cell shows as ... 19 Apr 2010 08:27