Knowledge focus: For example: sheet1 AB 1 001 003 2 002 -004 Issue 1: If A1 in Table 1 to Table 2 AutoFill A1? Question 2: If A1 is positive in Table 2 to Table 3 to automatically fill the A1; If a negative to fill in Table 3 A2 1,
nike basketball shoes, in Table II A1 enter = sheet1! A1 and press Enter 2,
nba shoes, ..
example: sheet1 AB 1 001 003 2 002 -004 Issue 1: Table 1 if automatically filled into the table in the A1 2 A1? Question 2: If A1 is positive in Table 2 to Table 3 to automatically fill the A1; if it is negative to populate the table 3 A2 1, in Table II A1 enter = sheet1! A1 and press Enter
2,
nba basketball shoes, in Table III A1,
nike lebron, enter = if (sheet2! A1> 0,
nike kobe v, sheet2,
lebron james shoes! A1, 0)
in Table III, enter = A2 if (sheet2! A1 <0, sheet2! A1, 0)
OK?