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!

Register Log in
  • Congratulations Rhinorhino 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: mcaoneill
  • Content: Threads
  • Order by date
  1. mcaoneill

    Excel Right function Maybe

    Let me see if I can explain this in english :-) I have 6 columns that have 8 5 rows with "a choise to be made" when the user selects choice 2 I want only the digit to be shown, after the choice is made. Example. Choice Improve Productivity by 25% - 5 " " 20% - 4 and so on...
  2. mcaoneill

    Link to Web for Stock Quotes

    Good Morning, I am trying to link a field in a form to the web to download current stock quotes once a day. I can input a hyperlink but I can't get it to return the actual price. Any ideas? Thank you Maureen
  3. mcaoneill

    Excel Formula

    Hi, I need some help this is the formula I have in my spreadsheet, =IF(ISERR(C8+28),"-",C8+28) it works great when cell C8 has a date in it but when there is no date in C8 it returns this value 1/29/1904. What I want to do is if there is no value inputted into C8, cell c11 is blank. Thank you...
  4. mcaoneill

    Excel Yes/No Two Different $ amounts

    Good Morning, I need excel to input into one column a dollar amount which depends on the input from another column. Column D is Yes or No, if it is yes, column E would have $2,000.00 and if Column D is No column E would have $415.00. Any help is GREATLY appreciated. Thank you Maureen
  5. mcaoneill

    Excel Calculations on Calculations???

    Hey, I am thinking this might be impossible, but I will ask. I have a spreadsheet (they do not want a database).For tracking patients in a clinical trial. I have thus far (with help from some brillant people here) set it up as follows: A B C D E F G H Pt #...
  6. mcaoneill

    What Statement to Use, IF Doesn't work

    Hi, Here is what I have Column C D E F Screening Cycle 1 Date Fail Cost Expected Start Date I have so when a date is entered into Screening Date cost populates, I need column F to populate with a date of (C3 +21) this will work but what I also need is where...
  7. mcaoneill

    Contact Tracking Database

    Yikes, I am not even sure where to start. I am creating a database for tracking all contacts with companies, so far I have created two tables, one for companies with the company ID, company name and website. I have also created contacts, with companyID, contactID, name, address, phone and...

Part and Inventory Search

Back
Top