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. bluedragon2

    Excel Formula for sliding scale commission

    ...: 0 2% 0 87,813 2.25% 0 107,814 2.25% 2.50% 127,815 2.25% 2.50% 999,999 2.25% 3% And put the sales amount in F1 and used the formula: =VLOOKUP(F1,A1:C5,1,1)*VLOOKUP(F1,A1:C5,2,1)+((F1-VLOOKUP(F1,A1:C5,1,1))*VLOOKUP(F1,A1:C5,3,1)) Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  2. bluedragon2

    How does SUMPRODUCT() work for Multiple Criteria Aggregations?

    faq68-4725 Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  3. bluedragon2

    How does SUMPRODUCT() work for Multiple Criteria Aggregations?

    Didn't like mine :) Looks good... Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  4. bluedragon2

    Multi column counting

    Try: SUMPRODUCT((A1:A5>B1:B5)*(A1:A5>C1:C5)) and adjust for each colmun Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  5. bluedragon2

    Excel 1st Integer 0 Drop

    Add an embedded if that checks to see if the number is less then 12. If so, "", if not, <formula> Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  6. bluedragon2

    tesxt files becoming data files

    Yes, this is a puzzle. These are application files. The application will append two of them, but the third is a read only for the application. The caveat to that is I have six different deployments of this setup and this is the only one it is happening on. The NAS is using VERITAS volume...
  7. bluedragon2

    tesxt files becoming data files

    Overview of setup: Sunray DTU session. Using terminal console to ssh to two different servers. The file resides on a NAS mount that has the same mount parameters on both servers. I have a copy of the original file on another server that is not on a NAS mount and it is still text. Some...
  8. bluedragon2

    tesxt files becoming data files

    sorry, binary/exe type file. If you cat it, it comes back like cat'ing an executable. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  9. bluedragon2

    tesxt files becoming data files

    I have text files that reside on a NAS drive that are text files. Over the past couple of months, three of the files are now data files. They are shared on three different servers and today when I noticed another file has converted, if I look at the same file on another server it is still...
  10. bluedragon2

    Excel 2010: Exlanation of formula for Thanksgiving date of current year

    To give you a breakdown of how the formula works: Main function is DATE() which gives output of an excel date by giving it the year, month, and day as criteria. D5 is the year. 11 is the month. Now, for the day: The weekday() function will return a number for the day of week a date falls on...
  11. bluedragon2

    Excel to work out date for the most recent Friday

    Nice one Tony, keep forgetting about the mod. Especially since I became management, all I do is e-mail anymore anyway :) Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  12. bluedragon2

    Excel to work out date for the most recent Friday

    Just need to add the logic: =IF(WEEKDAY(TODAY())>5,TODAY()-(weekday(today())-6),(TODAY()-WEEKDAY(TODAY())-1)) Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  13. bluedragon2

    Excel to work out date for the most recent Friday

    Look at the weekday function and you should with logic utilize it for what you need Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  14. bluedragon2

    Excel 2010 Formula Conundrum. Referencing a &quot;&quot; cell in a further formula

    In cell J49 you can put: =IF('SheetA'!K49 + 'SheetB'!K49=0,"",K49/I49) and not worry about the formatting. But, all you are doing is working off the original formula which is OK for reporting, but if you need to further utilize data from this page, then you will run into the same issue. Blue...
  15. bluedragon2

    Column Formula

    =A1 & B1 and if you need a space: =A1 & " " & B1 Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  16. bluedragon2

    Date and Time diffrence

    Nice approach Skip, I wrote down the IF/THEN's of where the start and end times would be and the formula would get out of hand in a hurry. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  17. bluedragon2

    Configuring Centralized Solaris Server to Receive Syslogs

    I would suggest looking at syslog-ng. It is very good at doing what you are asking for. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  18. bluedragon2

    Date and Time diffrence

    If I understand your question correctly, you want the total time between the two dates and exclude any time that falls between 0100-0800. If that is correct, you can do difference between the times and exclude 7 hours per day. The caveat is determining if the begin or end times fall within...
  19. bluedragon2

    excel 2007 attachments opening in read only mode

    Right click on the folder and choose properties. Under the popup chose security and click on the users name. The security settings should be evident on what is required. Blue [Dragon] If I wasn't Blue, I would just be a Dragon...
  20. bluedragon2

    excel 2007 attachments opening in read only mode

    IS the temp directory that the files are opened in have the appropriate permissions for this user? Blue [Dragon] If I wasn't Blue, I would just be a Dragon...

Part and Inventory Search

Back
Top