
word
根据提供的原文,我对你的问题做了一次改写:=IF(D2>90, "好", "")The use of quotation marks around the
word "good" indicates that it should not be displayed if the condition is not met. The IF statement is a logical condition used in
excel to test if a range of cells meets cert
AIn criteria, and returns a specific value if the criteria are met. For example, in the formula provided: =IF(D1>=80, IF(D1>90, "good","合格"), "不合格")In this formula, the first condition checks if the value in cell D1 is greater than or equal to 80. If this condition is met, it moves on to check if the value in cell D1 is greater than 90. If both conditions are met, it returns the text "good". Otherwise, it returns an empty string () which represents no value or no information.