Forum Discussion
An error in the formula that chatGPT made me
=IF(A1<=10, A2*0.4, IF(AND(A1>10, A1<=50), A2*0.2, IF(AND(A1>50, A1<=200), A2*0.1, ""))) < A3, "Yes", "No") Condition for the formula: You need to determine in which range of numbers the number in ...
Startsun
"If the resulting value is less than in cell A3, the value “Yes” will be displayed, if less than “No”"
> I assume if it is less than in cell A3, then "Yes", if it's greater than in cell A3, "No")
=IF(IFS(A1<=10,A2*0.4,AND(A1>10,A1<=50),A2*0.2,AND(A1>50,A1<=200),A2*0.1)<A3,"Yes","No")
