Can we use MS Excel to connet to a database namly DB2
2006-11-02 07:35:20 · 3 answers · asked by anand s 1 in Computers & Internet ➔ Programming & Design
You need to setup an ODBC or JDBC connection to your database in order for you to be able to 'link tables'.
2006-11-02 07:37:53 · answer #1 · answered by jimponder 5 · 0⤊ 0⤋
Assuming A1 and B1 have headings, and all values in column A are rather between the three particular, then commencing from B2 you ought to use: =IF(A2="Hero a million", "Batman", IF(A2="Hero 2","Superman" , "Spiderman") ) If there are the different values interior the checklist or sparkling cells, then you definately could do it as following to depart a sparkling in B: =IF(A2="Hero a million", "Batman", IF(A2="Hero 2","Superman" , IF(A3="Hero3", "Spiderman"," ") ) ) as quickly as you have your formulation, replica all of it the way down to beside the final merchandise in column A.
2016-10-03 05:24:10 · answer #2 · answered by shimp 4 · 0⤊ 0⤋
yes, you can
2006-11-02 07:36:25 · answer #3 · answered by zombie 5 · 0⤊ 0⤋