如果声明为RAG声明 [英] If statement for RAG statement

问题描述

我在sharepoint中有一个老化的列，我想反映显示RAG（红色，琥珀色和绿色）状态基于每个案例的老化天数。

I have an aging column in sharepoint, that I would like to reflect show RAG (Red, Amber and Green) status based on the amount of days each case has aged.

老化< 15绿色

Aging<15 Green

老化> = 15< 30琥珀色

Aging >=15<30 Amber

老化> = 30红色

Aging >=30 Red

状态只能显示单词"绿色" ，"琥珀"和"红色"。

Status can just display words "Green", "Amber" and "Red".

获得此声明的if语句是什么？

What would be the if statement to achive this?

推荐答案

您好

创建一个计算字段并输入以下公式。

Create a calculated field and enter below formula.

=IF([Aging]<15,"Green",IF([Aging]<30,"Amber","Red"))

这篇关于如果声明为RAG声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！