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 gkittelson 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: *

  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

    THANK YOU THANK YOU THANK YOU, I have been beating my head against the wall for three days! Maureen
  4. 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...
  5. mcaoneill

    Excel Yes/No Two Different $ amounts

    Marry Me?? Thank you very much Have a great day
  6. 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
  7. mcaoneill

    Excel Calculations on Calculations???

    Glenn, Thank you so much, it works perfectly. Best wishes Maureen
  8. 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 #...
  9. mcaoneill

    What Statement to Use, IF Doesn't work

    Thank you Skip & Tony, Both of these solved the problem. Have a great day Maureen
  10. 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...
  11. 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