Functions

In Excel, changing a range of cells to all caps.
I would like to know how to change a range of cells from mixed- or lower-case to all upper-case in Excel. ... 1 Apr 2010 12:24

Round formula
How can I round 980 to 1,000? ... 4 Apr 2010 23:41

How do I create a travel expense report by employee, by campus
I have the same problem.. but different data (of course) 1. Employee 2. Travels to multiple countries 3. Dates of travel 4. actual days on a particular country Goal: get actual days match travel expenses billed. thanks "Pete_UK" wrote: You need to explain more fully what data you have, how it is laid out... 1 Apr 2010 10:10

Think I need a MAX / MIN formula here (help needed)
Hi Again I need a formula that does the following A1 = 41 B2 = 39 C2 = 6 =IF(B2<A1),C2 BUT DO NOT EXCEED A1 Therefore this should return 2 Any ideas Thank you ... 1 Apr 2010 11:16

Range of values
Excel 2007 How do I make a range of cells values from 100 to 500 with increments of 5, i.e., 100+5...(100 105 110 115 120...500) ... 31 Mar 2010 22:11

Consecutive numbering
Hope someone can help. How can I get one cell (B35) on each of 100 worksheets to number consecutively? TIA Esra (*-*)< ... 1 Apr 2010 06:49

Remove Last x Character(s) in Selected Cells
This formula works great! But, can you explain/translate the formula? "Barb Reinhardt" wrote: Here's an equation to do it in helper column =left(A1,len(A1)-2) Do you need it in a macro? "rojobrown" wrote: How do you remove the last two digits in a cell using a macro? ... 1 Apr 2010 02:32

Unique filtering to another sheet ?
I having difficulty with unigue filtering. Probably because it's too close to tommorrow. I have a range of numbers in a column. There may be up to a hundred rows. I want to copy only the unique numbers to another column on another tab. Is that possible ? 599 478 478 478 478 982 982 785 894 Thanks, ... 1 Apr 2010 14:39

IF formula not working
Can anyone tell me why this IF formula isn't working? =IF(D5<E5<F5,"A",IF(D5>E5>F5,"B", IF(D5<E5>F5,"C",IF(D5>E5<F5,"D","F")))) It's returning "B" every time. D5, E5, and F5 are all derived from formulas. Is that the problem? I appreciate any help! ... 31 Mar 2010 16:37

Looking a value up for a
Hi guys, Here's a challenge I hope you can help me solve. Say I have a table of values with X and Y headers and a 3 x 3 array hoding parameters that are a function of X and Y, call these f (X, Y) as below. Y 0.1 0.2 0.3 1 10 15 20 X ... 31 Mar 2010 16:37