Forum Discussion

Copper Contributor

May 06, 2018

Solved

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...

Libro1.xlsx10 KB

Formulas and Functions

Haytham Amairah
May 06, 2018
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

Juan Manuel García Valverde

Copper Contributor

May 06, 2018

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 Amairah

Silver Contributor

May 06, 2018

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

Juan Manuel García Valverde
Copper Contributor
May 06, 2018
Haytham Amairah wrote:
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

Hi Haytham!
Perfect!!! Thank you for being there!!! Regards!!! :)