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 derfloh 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: FYRGUY
  • Content: Threads
  • Order by date
  1. FYRGUY

    Return a number only if greater than another number?

    Greetings, In MS Excel, in a single worksheet, I am trying to sum cells F17 & O21 and put the answer in cell O22. I have a certian critera that follows. I have tried =IF and =SUMIF and can't seem to figure it out. Probably simple but I am out of attempts. Here is what I am trying to do spelled...
  2. FYRGUY

    Return a number only if greater than another number?

    Greetings, I am using MS Excel. In a single worksheet, I am trying to sum cells F17 & O21 and put the answer in cell O22. I have a certian critera that follows. I have tried =IF and =SUMIF and can't seem to figure it out. Probably simple but I am out of attempts. Here is what I am trying to...
  3. FYRGUY

    Setting "Solid" fill as the default?

    I am using AutoCAD LT 2005, I am setting my defaults under the "aclt" template file (which is the default page I have set to open new drawings). I have set several items, however can't seem to set the default fill to solid. Can I do that?, and if so, could someone go through step by step on...
  4. FYRGUY

    Editing an Exel read only file if not the creator

    Hello everyone, I have a file (P.A.)in a folder (Dept Forms) on a server at my work. This form,an excel file, is used by all employees accessed by a common server. When "I" open the file it is a "read only" file. Only the creator of the form can edit it under the same name, I can edit it but...
  5. FYRGUY

    Editing Excel file on server?

    Hello everyone, I have a file (P.A.)in a folder (Dept Forms) on a server at my work. This form,an excel file, is used by all employees accessed by a common server. When "I" open the file it is a "read only" file. Only the creator of the form can edit it under the same name, I can edit it but...
  6. FYRGUY

    Can Excel count only positive numbers in a column?

    Can anyone give me the formula for Excel to count only positive numbers in a column? I have a sheet that will have mostly positive numbers in a particular column, however, I do not want it to subtract (or add) any that are a negitive number because I am sending the negitive numbers somewhere...
  7. FYRGUY

    Can a formula control a cell color also?

    This is just "fluff" for my spreadsheet, however I wondered if Excel can control a cell color in an "=if" or other formula. Can it change a cell "green" for a "true" referance and "red" for a "false" referance? If so could someone give me a sample of a formula. Thank you. Chris
  8. FYRGUY

    =if( ?? ) problem?

    Greetings- I have an excel spreadsheet that I have been working on. The formula that I am using in cell P3 is =if(A8=32,D8,"") This works great if only the number "32" is in cell A8. I need it to do the same calculation if there are other numbers with the 32 in that cell. Example: 32,10 or...
  9. FYRGUY

    Can Excel count how many "10"'s are in a column?

    I have a column, lets say "A" that I enter a number, lets say "10" (no quotes)that will return a text in column "B". Can excel count how many "10"'s there are in a column but not count the actual number? Example: A B 10 On duty 10 On duty 12 Sick 15 Vacation 10...
  10. FYRGUY

    MS Excel "IF" formula??

    I am looking for help on entering a formula in an Excel spreadsheet. I would like to enter a number in one cell and have another cell return a text. Entering a different number in the same first cell would return a different text. Example: I enter the number "10"(no quotes) into cell A1 and...
  11. FYRGUY

    Envelope tool?

    I was under the impression that the "envelope" tool puts a selected object and fits it into the second (closed) object. I am having problems figuring this out. Can anyone help me with this. Thanks Chris
  12. FYRGUY

    Lineweight scaling on xref?

    I am having trouble with the scaling of a line in a xref file. Other lines are coming across scaled properly but I have one line type called Railroad trax for a map I have drawn. On the xref file the line is just a single line without the look of RRTRX. I am using AutoCAD LT 2005. Does...

Part and Inventory Search

Back
Top