OFFICE函数IF 范围公式设定

根据提供的文字描述，可以改写为以下形式：If the condition that AY4 is less than or equal to 80% is true, the result will be 200. Otherwise, if the condition that AY4 is greater than 100% is true, the result will be 500. However, if this condition is not met, the result will be assumed to be 100000 (assuming that AY4 is less than or equal to 80%). In order to express the two conditions using logical AND, both "AND" and "*" can be used. Please note that I have included additional information regarding the assumed value when AY4 is less than or equal to 80%.