When the value of A1 for a certain interval, B1 changes
For example:
A1 is greater than or equal to 95, B1 for "A";
A1 is greater than or equal to 90, less than 95, B1 as "B";
A1 is greater than or equal to 85, less than 90, B1 for "C";
As with "if" function, but baidu for half a day, not a ok,
CodePudding user response:
B1= if (a1 & gt;=95, "A", the if (a1 & gt;=90, the "B", the if (a1 & gt;=85, "C", "?" )))A simple formula, there should be no problem