来自MSN3 个月
Every Excel Pro Needs to Understand IF and SWITCH: Here's How They Compare
An IF statement returns a value based on a TRUE/FALSE evaluation ... You can also insert them into other functions, such as SUM, INDEX, MATCH, and XLOOKUP.