Recent content by bluedragon2

I didn't look at any of the workbooks, but I did create a table (a1:c5) : 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...

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

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

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

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

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

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

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

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

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

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

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

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

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

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