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

  1. FYRGUY

    Return a number only if greater than another number?

    Thanks to everyone. Until next time... Chris
  2. FYRGUY

    Return a number only if greater than another number?

    Thanks Skip. Chris
  3. FYRGUY

    Return a number only if greater than another number?

    Thanks Skip. Can you shed any light on the ";;" after General in my last post? Chris
  4. FYRGUY

    Return a number only if greater than another number?

    Tony, The "General;;" worked perfect, Thank you. Could you briefly explain the ";;" behind General. I wasn't even aware of something like that. I assume there are other special symbols that do things. Is there a good book or a place I could reference these. Thanks again Chris
  5. FYRGUY

    Return a number only if greater than another number?

    Sorry it took so long for my reply back to everyone. I will give these suggestions a try. Thank you very much Chris
  6. 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...
  7. FYRGUY

    Return a number only if greater than another number?

    Sorry, & thanks
  8. 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...
  9. FYRGUY

    Setting "Solid" fill as the default?

    Thank you CarlAK. I am not sure on the "adac.lsp"? I will check with an IT guy here at work and see if he can help me do that. Thank you Chris
  10. FYRGUY

    continuous vectoring

    Just a thought... Under the object manager docker, re-arrange the order to your liking. This may not be the absolute fix, however, can be very effective to minimize travel on the laser head. The laser will vector in the order from top to bottom on the list. Hope this helps... Chris
  11. FYRGUY

    Setting "Solid" fill as the default?

    OK, I thought that fixed the fill, but it didn't. It still will not make it the default when I open a new page. Any ideas?? Chris
  12. FYRGUY

    Setting "Solid" fill as the default?

    Thanks CarlAK!! I entered it in the command line, then realized that it meant "Hatch Pattern Name".. Entered "solid"... boom done. Thanks!!!! Chris
  13. FYRGUY

    Setting "Solid" fill as the default?

    Thank you for the reply, I do not know exactly what you mean? I am assuming that I enter that at the command line at some point? Could you please explain just a little more? Thanks Chris
  14. 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...
  15. 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...
  16. 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...
  17. FYRGUY

    Can Excel count only positive numbers in a column?

    Thank you so much. I am sitting here laughing about my "addif". Once I read your first reply I tried the "SUMIF" (which only makes since!!)and it worked great. Thank you very much. I do not know where the "addif" came from....... Chris
  18. FYRGUY

    Can Excel count only positive numbers in a column?

    My apoligies...... I need it to "add" the positive numbers. sorry. Is there a "addif"? Thank you Chris
  19. 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...
  20. FYRGUY

    Can a formula control a cell color also?

    Thank you Brad, Your explaination was perfect for me, Thank you!!!! Chris

Part and Inventory Search

Back
Top