-
peng111说:
ifs函数怎么写多个条件的词语
ifs函数可以用来对多个条件进行判断，可以使用以下语法：
ifs(condition1, result1, condition2, result2, …, default)
其中，condition1、condition2等分别表示不同的条件，result1、result2等表示不同的结果，default表示如果所有的条件都不满足时的结果。
例如：
ifs(score = 80, "优秀", "不评级")
上述函数表示：如果score小于60，则结果为“不及格”；如果score小于80，则结果为“及格”；如果score大于等于80，则结果为“优秀”；如果所有条件都不满足，则结果为“不评级”。
-
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register LoginPopular Topics - 热门主题
-
14851
-
04973
-
03150
