Forum Discussion
Problem with if function
Hello Community!
I have a problem with the IF function. I get the following error when I want to use it. My idea is to nest several logical tests within the IF function. For example: establish ranges of data so that I return a response to them. It should be noted that IF appears in the function, which is the same as IF. To this end, I enclose my Excel sheet and leave a screenshot of it. Thank you very much for your cooperation, Regards, Juan Manuel
Hi Juan,
Sorry about that, I think that the separator between formula arguments should be a semicolon ( ; ) not a comma, depending on the locale in your operating system.
So please use this formula instead:
=SI(A2<600;"Malo";SI(A2<750;"Promedio";SI(A2<900;"Bueno";"Excelente")))
Regards
- Haytham AmairahSilver Contributor
Hi Juan,
As shown in the screenshot above, there is a point ( . ) after the number 900, this the reason for the error!
You have to replace the point with a comma as follows:
=SI(A2<600,"Malo",SI(A2<750,"Promedio",SI(A2<900,"Bueno","Excelente")))
I hope this helps you
Haytham
- Juan Manuel GarcĂa ValverdeCopper Contributor
Haytham Amairah wrote:Hi Juan,
As shown in the screenshot above, there is a point ( . ) after the number 900, this the reason for the error!
You have to replace the point with a comma as follows:
=SI(A2<600,"Malo",SI(A2<750,"Promedio",SI(A2<900,"Bueno","Excelente")))
I hope this helps you
Haytham
Hi Haytham!I thank you for the answer, I have changed the period (.) by the comma and keeps giving error. Excel paints me the error from the sentence: ... "600," malo ", si..."
- Haytham AmairahSilver Contributor
Hi Juan,
Sorry about that, I think that the separator between formula arguments should be a semicolon ( ; ) not a comma, depending on the locale in your operating system.
So please use this formula instead:
=SI(A2<600;"Malo";SI(A2<750;"Promedio";SI(A2<900;"Bueno";"Excelente")))
Regards