Functions

IF statement based on True/False that activates a certain list box
I've been asked to create a formula that will react to either "yes" or "no" entered into a cell which will show options in another cell based on a certain list. Example: Cells D3:D5 contain the values Monday, Tuesday, Wednesday (list named BegWeek) Cells E3:E5 contain the values Thursday, Friday, Saturday (li... 19 Mar 2010 02:44

Addition to a working formula
I have this formula and it works fine. =IF(OR(S140="No",S140="0"),"",G140*X140) This is placed in cell p159 I now need to add the exact same information as above to the cells immediately below the cell listed above. so Orinal cells involved G140 = data s140 = yes/no x140= % I now need th... 19 Mar 2010 06:00

What caused my paste function not to work?
Even I checked the box under tools/edit/show paste button, I can not copy and paste from one excel workbook or file to another. How can I make the paste function work again? When I am in a work book, or click on Edit, the "paste" option is not highlighted on the toolbar. ... 19 Mar 2010 10:48

loan amortization template
I can't find a loan amortization table that will accept a term of 40 years; the max is 30. Can anyone help? Thanks -- Sue W. ... 18 Mar 2010 20:07

Use CountIf for a literal string
I am trying to count the number of cells in a range that contain the string <0.1. I don't want the number of cells that contain numbers less than 0.1, I want the actual string. Is there an escape character for comparison operators like the tilde for wild cards? Thanks, Chad ... 21 Mar 2010 00:29

Hlookup with Merged cell as look up value
Hopefully someone can help me out on this one. I have a spreadsheet that looks similar to this: 2/15/2010 3/15/2010 . . . Site# INV VALUE INV VALUE 1 34 332 40 440 2 47 250 47 250 3 ... 18 Mar 2010 18:59

Conditional Formatting with 3 Criteria Options
I would like a Cell's Text to turn green if A1=B1, but turn red if A1<>B1, and no formatting if B1 is blank. What is the best way to go about this? I have excel2007. ... 19 Mar 2010 01:39

Restrict data entry in a cell
Hi, I would like to ensure that a user can only input one of the following numbers in a cell: 1, 2, 3, 4, 5, 6, 7 or 10 I'm using Excel 2003. Thank you Ephraim ... 18 Mar 2010 18:59

Conditions Not Accurate when subtracting time
When I subtract two times e.g. b1 is 21:35 a1 is 20:55 the answer shows correctly i.e. 40:00 (using [m]:ss format) but when I set the condition b1-a1>15 the answer is FALSE. How do I subract two times and then check if the result is greater than a value I specify? ... 18 Mar 2010 16:39

formula patterns with a gap of two
"Mr L Hibbert" wrote: hello im trying to compile a small folder consisting of different worksheets, each worksheet is a different customers sales etc.... with totals for JAN, FEB etc throught to the year, these totals for each customer month are to be summarised in a summary spreadsheet, how do i extrac... 18 Mar 2010 14:22