Home » Category » Microsoft Excel

Microsoft Excel

• "#DIV/0!" -->>> I'd like the best way to check for Error.Type into my formula...

• Using Excel automation, my vb program puts this formula into a range: formula = "=100*(1-(AVERAGE(C3,E3,G3,I3,K3,M3,O3,Q3,S3)/AVERAGE(B3,D3,F3,H3,J3,L3,N3,P 3,R3)))" on rare occasions inside the cells this formula refers to, I find this error message in one of those cells "#DIV/0!" how do I put...
• Fri, 23 May 2008 20:17:00 GMT | 763 bytes

• "#N/A" Result From VLOOKUP Formula

• I need a way to return a value of 0 when a formula results in a #N/A value. Can this be done? My problem is where I have a VLOOKUP and the lookup value does not exist....
• Thu, 22 May 2008 18:00:00 GMT | 175 bytes | Answers (3)

• "#REF!" not being picked up

• I have five cells named Sub1, Sub2,, Sub5 My Sub4 cell currently shows #REF! since its source row was deleted. I'm trying to copy all names over to sheet2 (where I want to Sum() all 5 values and naturally replace the #REF! with a 0 (zero) but as I step through the code the If line is never...
• Thu, 22 May 2008 07:10:00 GMT | 642 bytes | Answers (7)

• "%^{F9}" doesn't cause calcaulation

• Hi all,I use Application.SendKeys "%^{F9}", True to cause calculation, but itfailed. My Excel version 2000.Clarathank you so much for your help...
• Sun, 01 Jun 2008 13:47:00 GMT | 176 bytes | Answers (9)

• "%^{F9}" doesn't cause calcaulation

• Hi all, I use Application.SendKeys "%^{F9}", True to cause calculation, but it failed. My Excel version 2000. Clara -- thank you so much for your help...
• Fri, 23 May 2008 01:10:00 GMT | 182 bytes | Answers (9)

• "&" character in header line

• How come whenever I put the "&" character in the header line of a document the resulting header removes the "&" and does strange things to the text following the "&" character? Does anyone know this?...
• Thu, 22 May 2008 18:59:00 GMT | 207 bytes | Answers (1)

• "&" in Excel footnote as text

• I've tried to use the "&" in an excel footnote with a "T" and it always turns into a time stamp, not BS&T, but shows BS[time]. How do I make it remain as a text symbol?...
• Wed, 04 Jun 2008 18:20:00 GMT | 181 bytes | Answers (1)

• "&" in Excel formula

• Could you please help. What means, does sign "&" in Excel formula. I have seen it in Hyperlink formula. Thank you in Advance piotr...
• Thu, 22 May 2008 05:50:00 GMT | 158 bytes | Answers (2)

• "&" in footer

• Hi How can i insert the "&"-sign in an excel-footer ? Just typing doesn't work, because "&" is treated as a formatting-character. Biff...
• Thu, 22 May 2008 21:17:00 GMT | 159 bytes | Answers (2)

• "&" in header disappears

• Using the ampersand "&" in the header as part of a company name, the "&" disappears. I recognize that Excel uses the "&", like &[file] and &[page], but why won't it show and print when used in the name of a company, such as "S & S Cafeterias"? Any help is appreciated. To reply to this messa...
• Wed, 04 Jun 2008 16:08:00 GMT | 353 bytes | Answers (2)

• "><" formula needed

• Xref: number1.nntp.ash.giganews.com microsoft.public.excel.programming:547344Hi Bart;You should be able to look in help for how to writean "If" formula to get what you want.Thanks,Greg>--Original Message-->Hi, I have numbers that I would like to compare to eachother and determine their rel...
• Mon, 26 May 2008 14:06:00 GMT | 966 bytes

• "><" formula needed

• Hi, I have numbers that I would like to compare to each other and determine their relationship to each other as to ">" or "<". Example:A B1 50 702 10 203 (result will go here)Is there any formula that I can enter into cell A3 to identify all the numbers to each other and return the followi...
• Mon, 26 May 2008 14:06:00 GMT | 536 bytes | Answers (2)

• "><" formula needed

• Hi, I have numbers that I would like to compare to each other and determine their relationship to each other as to ">" or "<". Example A B 1 50 70 2 10 2 3 (result will go here Is there any formula that I can enter into cell A3 to identify all the numbers to each other and return the followin...
• Fri, 23 May 2008 07:46:00 GMT | 527 bytes | Answers (3)

• ">=" usage in a function

• Hello to all, I have the following function that I'm using without incident - COUNTIF(L12:L65536,">=4"). It simply tells me how many times the value 4 or larger exists in column "L" between rows 12 and 65536. However, I want to be able to change "4" to a cell reference, where I can put in a...
• Thu, 22 May 2008 03:50:00 GMT | 544 bytes | Answers (3)

• ">=" usage in a function

• Hello to all,I have the following function that I'm using without incident -COUNTIF(L12:L65536,">=4"). It simply tells me how many times the value 4 orlarger exists in column "L" between rows 12 and 65536.However, I want to be able to change "4" to a cell reference, where I canput in any...
• Fri, 30 May 2008 21:21:00 GMT | 543 bytes | Answers (3)

• ">="&

• For some of the queries that I have posted, people have very kindl given me the correct formulae to use. Some of these have included (for example =countif(A1:A100,">="&date(2004,9,1))-countif(A1:A100,">"&date(2004,9,30)) Please could someone tell me what the & actually does and how best t use it...
• Thu, 22 May 2008 22:27:00 GMT | 538 bytes | Answers (3)

• Microsoft Excel Questions...

• I have VLOOKUP function, because I have some codes, that I used for differents rates... so, if I pick-up 96714, I get code rate 124 if I add an * (96714*) i get rate table 224... but one problem... if a enter only the "*" i get the same table, which is wrong, every zip code is different... any s...
• Wed, 04 Jun 2008 11:57:00 GMT | 340 bytes | Answers (3)

• "*BETWEEN*"

• What does: IF(COUNTIF(D2,"*Honda*"),"Honda",D2) this formula do' i.e. what do the *______* accomplish' Thanks, FLKulchar...
• Fri, 23 May 2008 02:14:00 GMT | 170 bytes | Answers (1)

• "." & a "+" added 2 a table reformatd as text in Word

• I'm needing to take info from 2 cells and merge them into one cell in excel. I copy the info, transfere it to word, change it from a table to text, replace the "." & "+" with nothing (which does work) and then copy and paste back to excel. When I do this, some of the cells, but not all add...
• Wed, 04 Jun 2008 15:01:00 GMT | 555 bytes | Answers (2)

• "." on numeric keypad displays ","

• Hello, When I type "." on my nummeric keypad (under the 3) then, in xls, a "," is displayed. How can I display a "." ? Thanks in advance for you help ! Tom...
• Thu, 22 May 2008 08:09:00 GMT | 183 bytes | Answers (11)