Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: KN3M3SIS
  • Content: Threads
  • Order by date
  1. KN3M3SIS

    Date Formula

    Date 1 Date 2 2003-11-13-14.17.16.000000 2003-11-14-16.02.55.000000 2003-11-06-08.14.32.000000 2003-11-06-10.28.03.000000 2003-10-31-13.22.19.000000 2003-11-13-12.14.07.000000 I have 2 fields (Date 1 and Date 2). I need a forumla to calculate the numbers of days...
  2. KN3M3SIS

    Hiding Things In Excel

    I have many cells that reference and make calculations from other cells. When these cells have no infomration in them they dislay "#DIV" or "0" or whatever else. I do not want the cells to have anything in them until something is entered. Is there a way to keep the...
  3. KN3M3SIS

    SPECIAL PRINT FUNCTION IN EXCEL

    I have about 300 Rows on an EXCEL sheet that I need to print. I need for each line to print on a seperate page with the headers included. How can this be done?
  4. KN3M3SIS

    Can This Be Done?

    Name Desc Review Date Berry asc O 9/01/02 Berry asc V 9/01/01 Berry asc E 9/01/00 Jamie salk V 9/01/02 Jamie salk V 9/01/01 Jamie salk V 9/01/00 Michelle rep U 9/01/02 Michelle rep U...
  5. KN3M3SIS

    COMPARING & FLAGGING

    I have to colums with similar data. Some are the same and some aren't. Colum "A:26" may have the number 987.23 and colum "B:26" may have 987.29... I need a formula that compare two adjacent cells and flags them by bolding or return a value in a differnt cell if they are...
  6. KN3M3SIS

    Days to Months Conversion (Tricky)

    I've recently used a formula that allowed me to take a start date and coompare it to the current date and it returns the number of TOTAL DAYS. Is there anyway that I can have it return the total number of months instead of days? Please advise, Thanks in advance.
  7. KN3M3SIS

    Think I have a good one here

    So I have a column with number that range from 0 - 2, then I have another that has some letters in it. I want to be able to do something like. If N# > 1 add the letter "A" to the string in B# Else add the letter "B" Example N B RESULT 1.4 VE AVE .9...
  8. KN3M3SIS

    Assigning Range Name

    I need help assigning a range name to a group of cells so that I can use the VLOOKUP command. Please help.
  9. KN3M3SIS

    EXCEL IF THEN

    Hello, I have a column (H:19,H:76) that assigns the variables AVE, AO, AE, BVE, BO, BE to various people. 1) I want to assign a value to each of the 6 variables 2) Then I want to have a column that does something like: IF (CELL H# = AO) THEN (CELL R# = BONUS * .045) ELSE IF (CELL H# = AE)...

Part and Inventory Search

Back
Top