Summary: hi! i have to generate student result in excel. for this i have to calculate grades. when i use the IF function like IF(column>80%,"A","B"). it displ...
Summary: Hello, I'm using MS office 2000, and in Excel i'm trying to come up with a formula combining 'COUNT' and 'IF' but can't seem to get it right. I would ...
Summary: bring up your list in ms access then there is an option under the tools menu to "analyze data using Excel". Select this option. Once this data is in...
Summary: I'm building a test matrix in Excel and for some reason the macro that I am writing is having a problem reading the cells in the range that I pass to ...
Summary: Does anyone know if/how you can change default margin settings in Excel 2000 so that anytime I create a new document, it uses my margins (.25 instead ...
Summary: I would like to compare four numbers in an excel spreadsheet and would like to assign positions to the numbers based on the numbers. The highest being...
Summary: Hi Can i return a picture in excel by using the if loop? i mean say if(A1=123, then a certain pic is to be returned, or else another message) ...
Summary: i have nos. in a series which is the amt. of time worked by each employee, eg. A1 has 1.2, B1 has 2.4, C1 has 1.5 i want the addition of the no. of hr...
Summary: Hi, I am very gud with excel and would like to knw how to write macros in excel (VB script). How to I go about it..where can I learn it. Can someone ...
Summary: I have a user who has this problem in Excel 2000 using W2K, 1Ghz, 256MB Ram(i know someone will ask for this info.): In excel, when he types in 16 dig...
Summary: I have three worksheets, named X, Y, Z, that contain data to be looked up. On my main page, I have a cell that contains the NAME of the worksheet I wa...
Summary: Can I put formula in one cell that has an action on another cell. EG.Can I put formula in A1: to add data in A2 and A3 with the sum to be appear in A4...
Summary: Can any one help!! im need to know if in excel 2000 there is any way to use 'objects' in list boxes?? any advice would be help full. Many thanks adam ...
Summary: Jeff, Use Excel to create your list, being sure to specify CN and DC information. Save the file in comma-delimited format (CSV). Then use the comman...
Summary: Hi :-) We are having a problem with Excel charts. Using a scatter graph we want to align the text labels on the x-axis vertical. When we do so it j...
Summary: Hello, Sorry if this message too long, but I will explain everything! The computer I am trying to fix originally had Win98 SE on it. The users were ...
Summary: Hi, Does anybody know why spell checking options are not available in Word97 when I log as a common User in Windows2000 whereas it works perfectly wel...
Summary: Hi, I have set of marks out of 100. Like 5,8,11,26,38,59,47,59,85,29,92 etc. I wanted to multiply all the marks by 2 if they are less than 20, multipl...
Summary: Hello: I am a self-taught private developer and have produced an extensive spreadsheet that relies on a variety of VB macros that are accessed through...
Summary: Dear users, I'm a reguler user of Windows98. But recently i have passeds 70-210 and 70-215 exams of MCSE 2000 track. Thats why its really important to...
Summary: I tried to mail merge Excel Worksheet in Word document. My problem is that i am taking numerics upto 2 decimal point in excel sheet but in word it is ...
Summary: Something weird has been happening in my excel worksheet. Sometimes when I am viewing the workbook on the screen one of the cells looks scrambled, bu...
Summary: Use the export function of CSVDE on a testuser in the active directory. The result is a CSV-file. You can edit this in EXCEL,add users in the same con...