You are here:

Excel/Expert Profile

Nathan Head

U.S.

On Vacation
returns 10/28/2012

Expertise

Microsoft Excel questions related to advanced formulas, Pivot Tables, filters, forms, graphs, and just about anything else (EXCEPT Visual Basic Coding/Programming and Macros, I don't answer questions in those categories).

This expert requests a donation of $3 for questions answered to your satisfaction. Isn't $3 a value for this experts time?

Experience in the area

I have been using spreadsheets since Lotus 1-2-3 was released. As a CPA, I use spreadsheets every day at work.

Education/Credentials

CPA, Texas

What do you like about this subject?

Learning something new and helping others learn something new!!

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
stephen	12/05/11	10	10	10	I'm so grateful. Thank you for your .....
Parantapkumar	11/30/11	10	10	10	Thanks So Much. This is exactly what .....
Rajesh	11/10/11	10	10	10	You are amazing... Thanks much.
Bhakti	12/30/10	10	10	10	thanks sir what i actually want u .....
David	12/28/10	10	10	10	Thank you Nathan for your help with .....

Recent Answers from Nathan Head

2011-12-02 mulriple conditions between cells:

Stephen: This can be done with an IF function. Here is an example (this function won't actually work because I'm using letters instead of numbers; however, I did this to follow your example): =IF(AND(A1>=a

2011-11-26 Time in Which Fraction:

Parantapkumar: A7 =ROUNDUP((A4-A1)/((A2-A1)/A3),0) B5 =((A2-A1)*(A5-1)/A3)+A1 C5 =((A2-A1)*(A5)/A3)+A1-(1/24/60/60) B6 =((A2-A1)*(A6-1)/A3)+A1 C6 =((A2-A1)*(A6)/A3)+A1-(1/24/60/60) B7 =((A2-A1)*(A7-1)/A3)+A1

2011-11-21 Hyperlink:

Meenakshi: There is a hyperlink function within Excel. The following websites explain how to use the function: http://www.techonthenet.com/excel/formulas/hyperlink.php http://office.microsoft.com/en-us/excel-help/hyperlink-HP005209116

2011-11-17 imported data and autosum:

Jacques: Having a comma as the thousands separator shouldn't prevent Excel from calculating a total. Instead, what may be happening (as a side effect of there being a comma in the cell) is those values

2011-11-16 Locking specific cells:

Hebron: Yes, Excel offers a feature to lock and protect cells. I have provided links to several websites explaining how to accomplish this task. One of them should be able to explain to your liking:

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Encyclopedia

Browse Answers: