Functions
in [Excel]
|
Combobox has no arrow, just a line on the right, what's wrong? I am trying to place a combobox in a spreadsheet (Excel 2002) but no down arrow appears only a line on the right side of the box. I have linked a cell and designated a range. ... 7 May 2010 14:32
in excel how can we put formula to convert numericalfigureto word for example : in excel i have mention 25000.00 in numerical amount , i want to know how can i convert in next colum , about word ?/; How can i put formula to make the numerical in to words like 25000 in numerical to twenty five thousands in word. ... 7 May 2010 07:50
Deleting Style 1 not found According to this site: http://www.mrexcel.com/forum/showthread.php?t=40950 The error results because you have more than the maximu number of Styles. Delete a few manually, then delete style 1. Worked for me... Paul wrote: Custom Cell Style - Shows as error and cannot be deleted 09-Apr-09 I am u... 6 May 2010 20:58
Is there a way to conditionally hide rows in Excel? I would like to be able to conditonally hide row based upon a value in a column of the spreadsheet. I assume I would need to create a macro, but I'm nt real good with macros. Can anyone help with this? Thank you. ... 6 May 2010 20:58
using a time format in a count function I have a spreadsheet that has the following: A B C Start Time Run Day Run Time 11/14/09 12:20 AM Sat 12:20 AM 11/15/09 3:30 PM Sun 3:30PM The cells are formatted as: A= Date & Time B=TEXT(A2,... 6 May 2010 18:45
If Function Function okay. So I am trying to workout a formula to compute a commision earning. Basically, if X amount of new business is made, then X*Y (corresponding Commision rate percentage), but if new business =<X, then X*Y (Commision rate percentage that is true). Problem is, it's super confusing...anyone have any suggestio... 6 May 2010 19:52
Site for some reason, and forbidden Site for some reason, and forbidden http://downfree.zymichost.com/free ... 6 May 2010 17:39
Sum with 2 if's I have a worksheet with the following data which are all results of formulas in each cell. On another worksheet, I need to sum all the amounts in Col C if Col A=1 AND Col B=No. Can anyone helpwith this in Excel 2003? Thanks. Here's some of my data: No No $- 1 Yes $7,011.08 1 Yes $1,017.77 No No $... 6 May 2010 17:39
VLOOKUP IS ERROR Can someone advise why this formula returns a "0" and not a blank? =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE)) Thanks. ... 7 May 2010 03:30 |