Combine IF Function with VLOOKUP ; E2 · =IF(VLOOKUP(D2,A2:B6,2,FALSE)>2500,"Yes","No") to cell E2. Press Enter to apply the formula in cell E2. ; E2 · = IF(ISNA( ...
確定! 回上一頁