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 ...
still showing error too
In English version it works
Perhaps you shall use semicolons instead of commas. Try to open attached file and check how formula looks in your environment.
SergeiBaklan I did everything as you said, but it still shows an error. I am attaching a photo below, in the first one with a comma, the other commas are replaced by a period and a comma. The language is Ukrainian
Please open the file I attached to the previous post, it shall be correct formula inside. Don't copy/paste it from this thread.
You should use
=IF(A2*IF(A1<=10; 0,4; IF(A1<=50; 0,2; IF(A1<=200; 0,1; 0))) < A3; "Yes"; "No")
i.e. ; to separate the arguments and , as decimal separator.
