Richard Roberts - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

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 Roberts

Expertise: Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.

Experience in the area
Have been working with Excel for about 15 years primarily in accounting and financial areas.

Education/Credentials
BA, CPA

Ask a Question	View Past Answers

This expert has elected not to be rated

Ask a Question	View Past Answers

Recent Answers from Richard Roberts

2008-12-02 Excel Help: Steve Unfortunately VLOOKUP is the best function to use to find your client needs. And as you know vlookup finds the first occurance, and when there are more it ignores them. What you can do is...

2008-12-01 IF AND VLOOKUP Statement: Steven I am not exactly sure of the question, but here is the answer anyway. The formula would look like this. =IF(AND(A1>=A2:A7,A1<=B3:B7),VLOOKUP(A1,C3:C7,1,FALSE),"") What I don't understand...

2008-11-28 Reg Date Minus Time: Akhil The trick to working with time and dates is to use the same formatting and the same numerical basis with all the cells being used and input the data using the same format. If you enter a date...

2008-11-26 Scoring a network: Anson If I am reading your question correctly, you should be able to use the countif function to get the answer. The formula might look something like this--- =COUNTIF(A1:A50,"yes")/(COUNTIF(A1:A50...

2008-11-23 MAX and Conditional: Tisa I'm not sure I fully understand the question, but---- What I think is the question is resolved as follows" It is a bit difficult to combine the formulas that you need, so I use three formulas...