为何IF函数公式正确,系统老提示公式错误

1个回答

写回答

18782963305

2025-10-26 17:30

+ 关注

word
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 certAIn 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.

举报有用(0)分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号