Functions
in [Excel]
|
error alert for invalid date hi I want excel showes error alert if user enters invalid dates like "2010/2/29"... I can not creat it on data validation. ... 27 Apr 2010 07:39
Index using a defined name array I have defined 3 arrays using DefineNames: Boys_11_12 Boys_13_14 Boys_15_16 I then have defined a Combo dropdown with the following choices: Boys_11_12 Boys_13_14 Boys_15_16 When the user selects the Boys age group using the Combo dropdown, I then use the selection in an Index function: Index(Boys_(one of... 27 Apr 2010 05:26
excel: How to set up a formula for a range of numbers ie. 3.5-5.. On Apr 27, 5:09 am, LadyK974 <LadyK...(a)discussions.microsoft.com> wrote: in a spreadsheet i have a range of numbers that needed to be counted ie. phos levels between 3.5-5.5 I can't find a formula to support this. Can you help Maybe have a look at the frequency formula. It takes the range of values y... 27 Apr 2010 02:09
Modify general format to date format. When importing from payroll, it gives me all dates formatted as general numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to convert these numbers into dates? ... 27 Apr 2010 08:47
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible In my old computer with Excel 2003 if I select automatic calculation my spreadsheet updates stock price quotes from an external link. In my new computer with Excel 2007, even though I select automatic calculation using Excel Options the spreadsheet won't update from the external price quote service. If I reboot... 26 Apr 2010 17:14
excel: How to set up a formula for a range of numbers ie. 3.5-5.. in a spreadsheet i have a range of numbers that needed to be counted ie. phos levels between 3.5-5.5 I can't find a formula to support this. Can you help ... 26 Apr 2010 22:52
Formula Help In my "Total Days" column, I have the following formula and it works: E4 is Date sent to Vendor =DATEDIF(A3,TODAY(),"d") now, I want to add to this formula, if possible, to say if a date is entered into the second column, then just calculate "Date Sent" - "Date Returned" in the same "Total Days" colu... 26 Apr 2010 14:57
Formula addition causes random #REF! I have added a new formula to ledger worksheets and now the #REF! appears in areas in the workbook. In order to fix it, all I have to do is copy a good cell with the formula (one that isn't showing #REF!) to on that is showing #REF! and all the cells in the workbook clear up. Any suggestions please? Thank yo... 26 Apr 2010 16:06
Is there a function to solve for an unknown in an equation? For example, the equation is: P*R - (P*G) = D + (D*G) In the worksheet, each cell would have a number associated with a variable and I would like to solve for G. Thanks, WA ... 29 Apr 2010 12:25 |