- Net send
Hello, I have designed a userform in excel that allow's a user to send messages via Windows "net send" facility. I would like to expand on this concept and allow users who have access to the tool to be able to communicate via the userform - a homemade messenger so to speak. I'm guessin...
- net present value
Excel stops calculating NPV at the end of 29 periods/years. How do I find tables that go up to 40 years?...
- nesting within vlookup
I am trying to nest an address in vlookup() for the table array without luck. Is this not allowed? IE: the table array is located at L:M VLOOKUP(I6,N1:M,2) where N1=L I get the #NAME error -- spxer --- spxer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37025 View th...
- nesting with statements
I was trying to do the following (to get away from the select) but am getting a "variable not defined" and it is highlighting xlInsideVerticle, or (if I take out xlInsideVerticle) error msg " wrong # of variables or invalid property assignment" and .Borders is highlighted, any suggestions would...
- nesting with countif
Hi, I am having trouble with nesting the and command in a sheet I am attmepting to prepare a spreadsheet to keep track of the clients in the various programs at the not-for-profit blind services agency where I work. I pasted a small piece of the sheet below. I used the countif function in the fo...
- NESTING THE IF COMMAND WITH THE OR COMMAND
I WANT TO CHECK CELL A1 FOR THE VALUE OF "X" I WANT TO CHECK CELL B1 FOR THE VALUE OF "X" I WANT TO CHECK CELL C1 FOR THE VALUE OF "X" I WANT TO CHECK CELL D1 FOR THE VALUE OF "X" IF ONE OR MORE OF THESE CELLS ARE EQUAL TO "X" THEN I WANT TO PUT "YES" IN CELL E1, IF THERE IS NO "X" IN ANY OF THE...