In cell C83, use the AND() function to determine whether the value of cell C2 equals to the value of cell C42 and the value of cell C2 is greater 0. Then Copy the formula to columns D through S.- In cell C85, use the OR() function to determine whether the Total Assets in the fiscal year 2009 is more than 400 billion or the Fixed Assets in the fiscal year 2009 is more than 10 billion.- In cell C86, use the IF() function to display the text "CIB" if the function in cell C85 evaluates to TRUE and "SME" if it evaluates to FALSE.
đang được dịch, vui lòng đợi..