Excel conditional formula
Hi all, I can write a basic conditional formula such as =IF(A1=”23″, “OK”, “NOT OK”), but I want to add a supplementary condition … For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate… both conditions need to be met. TIA, John
Answer Question
| February 1, 2013 8:46 AM
Microsoft Excel, Microsoft Excel formulas
Hi all, I can write a basic conditional formula such as =IF(A1=”23″, “OK”, “NOT OK”), but I want to add a supplementary condition … For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate… both conditions need to be met. TIA, John
Answer Question
| February 1, 2013 8:46 AM
Microsoft Excel, Microsoft Excel formulas
DSI file
Hello , I have Capital Harness, I tried to export DSI file and this operation is ok but I want to open this DSI file by HarnessXC. Is it possible or no? N.B: The version of Capital Harness is 2011. Thank you in advance.
Answer Question
| February 1, 2013 8:24 AM
Capital Harness 2011, DSI file
Hello , I have Capital Harness, I tried to export DSI file and this operation is ok but I want to open this DSI file by HarnessXC. Is it possible or no? N.B: The version of Capital Harness is 2011. Thank you in advance.
Answer Question
| February 1, 2013 8:24 AM
Capital Harness 2011, DSI file
Cursor is returning previous values in SQLRPGLE
I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check [...]
Answer Question
| February 1, 2013 5:10 AM
AS/400, SQLRPGLE
I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check [...]
Answer Question
| February 1, 2013 5:10 AM
AS/400, SQLRPGLE
Outfile for WRKJOB command.
HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now [...]
Answer Question
| February 1, 2013 9:30 PM
AS/400, AS/400 commands, AS/400 jobs
HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now [...]
Answer Question
| February 1, 2013 9:30 PM
AS/400, AS/400 commands, AS/400 jobs
QR-Code (barcode)
I represent H&R international transportation..we are in study to buy your Crystal Reports 2011. My question can your product create QR-Barcodes? If so how?
Answer Question
| January 31, 2013 9:09 PM
crystal reports 2011
I represent H&R international transportation..we are in study to buy your Crystal Reports 2011. My question can your product create QR-Barcodes? If so how?
Answer Question
| January 31, 2013 9:09 PM
crystal reports 2011
Option buttons in Excel
Trying to create a checklist with multiple line items each having a “yes” or “no” response.
Answer Question
| January 31, 2013 8:56 PM
Microsoft Excel, Microsoft Excel commands
Trying to create a checklist with multiple line items each having a “yes” or “no” response.
Answer Question
| January 31, 2013 8:56 PM
Microsoft Excel, Microsoft Excel commands
Excel
All of a sudden when I open a number of Excel docs, I don’t see the list on the bottom of the page to click and retrieve. I have to go back up to open and then open them from there.
Answer Question
| January 31, 2013 8:56 PM
Microsoft Excel, Microsoft Excel 2007
All of a sudden when I open a number of Excel docs, I don’t see the list on the bottom of the page to click and retrieve. I have to go back up to open and then open them from there.
Answer Question
| January 31, 2013 8:56 PM
Microsoft Excel, Microsoft Excel 2007
Samsung phone won’t connect to Wi-Fi
Router password will not open connection for phone.
Answer Question
| January 31, 2013 7:41 PM
Mobile, samsung
Router password will not open connection for phone.
Answer Question
| January 31, 2013 7:41 PM
Mobile, samsung
Validate date in COBOL/400
I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400…. Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.
Answer Question
| January 31, 2013 7:22 PM
COBOL, COBOL/400
I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400…. Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.
Answer Question
| January 31, 2013 7:22 PM
COBOL, COBOL/400
Email groups with Gmail?
Wish to create group folders within Gmail to send batch emails. How can this be done?
Answer Question
| January 31, 2013 7:17 PM
Batch emails, Gmail
Wish to create group folders within Gmail to send batch emails. How can this be done?
Answer Question
| January 31, 2013 7:17 PM
Batch emails, Gmail
How to check DBI version on IBMi v7r1
Hi I would like to know how to check the version of DBI that we are running. We have IBMi v7r1 and zend server 5.6.0.
Answer Question
| January 31, 2013 6:51 PM
DBI, IBMi, Zend Server
Hi I would like to know how to check the version of DBI that we are running. We have IBMi v7r1 and zend server 5.6.0.
Answer Question
| January 31, 2013 6:51 PM
DBI, IBMi, Zend Server
Angle format
How to change the angle format to show leading zeros?
Answer Question
| January 31, 2013 4:54 PM
angle format
How to change the angle format to show leading zeros?
Answer Question
| January 31, 2013 4:54 PM
angle format
Change from AT&T
Have been having problems with AT&T internet and my 3rd modem. What is involved with switching to Comcast? I would have a new email address and that would be my only hold up as I have many customers who use my AT&T mail. Rosemarie
Answer Question
| January 31, 2013 3:09 PM
Internet connection, Modems
Have been having problems with AT&T internet and my 3rd modem. What is involved with switching to Comcast? I would have a new email address and that would be my only hold up as I have many customers who use my AT&T mail. Rosemarie
Answer Question
| January 31, 2013 3:09 PM
Internet connection, Modems
Examples of AS/400 create alias in Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
School Wi-Fi
Hello. I am an Austrian pupil who is being educated to become a computer scientist. My current problem is that my school (about 750 people) needs WiFi. The WiFi is supposed to be usable with any Wi-Fi device (Phone, Tablet, laptop,…). However our teachers are supposed to operate without any blocks while the students are [...]
Answer Question
| January 31, 2013 2:01 PM
Access Control Server, Wi-Fi, Wi-FI connection
Hello. I am an Austrian pupil who is being educated to become a computer scientist. My current problem is that my school (about 750 people) needs WiFi. The WiFi is supposed to be usable with any Wi-Fi device (Phone, Tablet, laptop,…). However our teachers are supposed to operate without any blocks while the students are [...]
Answer Question
| January 31, 2013 2:01 PM
Access Control Server, Wi-Fi, Wi-FI connection
QTEMP file not removed
In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I’m [...]
Answer Question
| January 31, 2013 1:23 PM
AS/400, iSeries, QTEMP
In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I’m [...]
Answer Question
| January 31, 2013 1:23 PM
AS/400, iSeries, QTEMP
Certification RPG
Hi, I am planning to do certification in AS/400. I don’t have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi
Answer Question
| January 31, 2013 10:01 AM
AS/400, AS/400 certification
Hi, I am planning to do certification in AS/400. I don’t have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi
Answer Question
| January 31, 2013 10:01 AM
AS/400, AS/400 certification
IP default 0.0.0.0
Teen messed with system config while downloading ( I don’t know). I did unsuccessful system restore from external drive. Config & drivers not right. Now all IP’s are set by default to 0.0.0.0. Can somebody please suggest where to start fixing this?
Answer Question
| January 31, 2013 7:13 AM
IP address, Windows 7, Windows 7 Administration
Teen messed with system config while downloading ( I don’t know). I did unsuccessful system restore from external drive. Config & drivers not right. Now all IP’s are set by default to 0.0.0.0. Can somebody please suggest where to start fixing this?
Answer Question
| January 31, 2013 7:13 AM
IP address, Windows 7, Windows 7 Administration
REORPO056 Error Message
I am creating a Move Plan in REORMP in SAP. I have a Participant and Target Room and I have activated the Move Plan. When I go to deactivate the Move Plan I get an error message. The error message number REORPO056 and says “Move-in 5105BDA49F7327A5E1000000834614EE: original entry 5105009EA1492BE3E1000000834614EE does not exist” How do I [...]
Answer Question
| January 31, 2013 3:04 AM
SAP, SAP error messages
I am creating a Move Plan in REORMP in SAP. I have a Participant and Target Room and I have activated the Move Plan. When I go to deactivate the Move Plan I get an error message. The error message number REORPO056 and says “Move-in 5105BDA49F7327A5E1000000834614EE: original entry 5105009EA1492BE3E1000000834614EE does not exist” How do I [...]
Answer Question
| January 31, 2013 3:04 AM
SAP, SAP error messages
