Recent content by calpolymis

Hello, yes, that seems to be right. Thanks for your logic to verify!

My answer is 33750. 22500 x 0.075 gives me pages of 100% ink. Now you devide by 5% to get the right answer. Is this right logic?

Hi, mintjulep . Thanks for your answer. Not sure if we're printing 2.5% more pages.. I guess one page gets 2.5% less coverage, but.. hmm.. Let me think about it. Thanks anyways.

I'd appreciate if you could tell your logic to get the answer, too. Thanks!

If you can print 22500 pages with 7.5% coverage on one page with an ink cartridge, how many pages can you print with 5% coverage?

I need some help how to write the correct vba function (if vba funtion is the way to go,) or if there's another way, I need some advice. Also, how to apply this funtion to my 500 items, not to just one item. Thanks.

Or below is my logic to achieve this. I found this sample code by googling and modified it. MyCaseFuntion() Select Case Range("A1").Value Case ( if value in A1 is greater than 0 and less than 2) Range("B1").Value = 200 Case ( if value in A1 is greater...

Hi, Andy. Actually, I'm not quite familiar with this (even though I worked in some vba codes before.) I don't know if this could be achieved by a funtion like VLOOKUP maybe? Or I need to develope macro vba. So, basically I need direction at this point, even before detail, even though I want to...

Hi, I need to develope a macro for Excel to calculate desired profit margin depending on our cost. Here's the scenario. A1: landing cost If 0 <= A1 <= 2, then multiply 200% to A1 and write the target profit margin on B1 If 3 <= A1 <= 5, then multiply 150% to A1 and write the target profit...

Hello, Duane. Thanks for your reply. So, is it something like this? If InStr([Title],"rep")>0 Then Me.[Title].BackColor = vbYellow Else Me.[Title].BackColor = vbWhite End If But where should I put that Expression if the above is correct? Thanks.

Hi. I want to change the background color of "item" field on Aceess report to yellow, if it contains text "special editoin."-without case sensitivity. How would I do this? Conditoinal formatting only enables number values, not text. Thank you for your help.

Hello, FredWagner. I'll look into that for a few laptops that are regularly used. My main concern is for the guests who visit our office and want to use internt. I'll see if my router has guest wireless functionality. I'll report it back shortly. Thank you.

Hi. I have a wireless router connected to our win 2003 network. Rough diagram is internet-> Linksys router -> wireless router & server -> switches The wireless router's IP is setup as part of our network (given static IP, subnet, gateway, and DNS) It's...

Before I posted my reply, I tried parsing as a text-It didn't work at that time, but it suddenly works now! I guess my Excel 2002 had a little functional glitch or something. Anyways, it is so nice to learn this kind of advanced functionality that Excel can offer. Thanks again~

Scott's solution worked like a charm! Thanks for other commentors-SkipVough's instruction worked too, but I could not sort the data correctly in the number field (I think XXXXX-A format is not sorted with other numbers, so I would probably need another tweak to handle that.) I will study...