About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert Login (Experts Only)
About Us  ·  FAQ  ·  Tell Friends About Us  ·  Link To Us  ·  Free Encyclopedia  ·  Disclaimer  ·  Tech Support   
  You are here:  AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Richard Stephens

Expertise:  Can respond to questions up to and including advanced (very rusty on VBA) Currently using Excel 2003 and Xp (can still remember some of the earlier excel programs. No question to basic.

Experience in the area
Teacher and business trainer for 5 years. Run my own small business Current on all versions of Excel

Ask a Question       View Past Answers       View Ratings            
Average Ratings
Prestige Points: 35436
Knowledge   9.85   Best of the best
Clarity of Response   9.86   Best of the best
Timeliness   9.83   Best of the best
Politeness   9.94   Best of the best
Number Of Questions
(in Past 24 Hours)
0
Max Questions to be Asked
(in 24 Hour period)
8
Total Questions
(since joining AllExperts)
2859
Recent Reviews from Users
KnowlClarityTimePolitenessDate
1010101011/25/08
1010101011/23/08
1010101011/21/08
1010101011/23/08
1010101011/16/08
User Comments
Thank you so much, I can't tell you how much time this will save me in the future. I had been trying to write this formula for quite some time, but I
(Carol on 11/25/08)
Thank you very much! Your answer was very quick, short and clear.
(Bozidar on 11/23/08)
Thanks so much, this works great, I figured there was an easy way to do, thanks again !
(June on 11/21/08)
Great quick response which detailed exactly what I required.
(Shay on 11/23/08)
thanks very much! quick and clear answer, just what i needed: cheers
(andrew on 11/16/08)
View All Comments
Ask a Question       View Past Answers       View Ratings            

Recent Answers from Richard Stephens
2008-11-24  FORMULA FOR 3 RATE BANDS alex The email isn't coming through in the message. =IF(A2>250120,((A2-250120)*0.03)+4001.36,IF(A2>100100,((A2-100100)*0.02)+1001,IF(A2<=100100,A2*0.01,))) Is the updated formula the 1001 is...
2008-11-23  FORMULA FOR 3 RATE BANDS Alex The formula is below, however it doesn't seem right as you only have asked for percentages over caps and don't have the additional amounts showing how much is payed at each level. =IF(A2>250120...
2008-11-23  Date Formula Carol You can create a formula using the Array Formula option (Ctrl + Shift + Enter) after typing in the formula. In F2 type in =SUM(IF(MONTH(B2:B29)=2,C2:C29,0)) Change B2:B29 and C2:C29...
2008-11-21  highlighting June Ctrl + Home to move the cursor to A1 or place the cursor using the mouse to the first cell that contains information then use the shortcut key combination Ctrl + Shift + End to highlight the data...
2008-11-15  Bank statement in Excel Michael This can be tricky because the bank may not use a standard rate, it can be variable every day, sometimes more than once a day. Without seeing the actual beginning and ending amounts makes it...
More Answers for "Excel"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.