How to stop FALSE being displayed

[ColdGeorge]

Hi all

In cell W103 I have this formula:
SI(Q103<>"",SI(Q103="Lunes",1,SI(Q103="Martes",3,SI(Q103="Miércoles",3,SI(Q103="Jueves",3,SI(Q103="Viernes",3,SI(Q103="Sábado",3,SI(Q103="Domingo","","")))))))) the thing is when Q103 is empty W103 displays FALSE, instead I prefer Q103 to hide FALSE. How can I do that? Thanks in advance.

ColdGeorge

 

[Fluff]

You need to add a false condition for the first IF

SI(Q103<>"",SI(Q103="Lunes",1,SI(Q103="Martes",3,SI(Q103="Miércoles",3,SI(Q103="Jueves",3,SI(Q103="Viernes",3,SI(Q103="Sábado",3,SI(Q103="Domingo","",""))))))),"")

or you can simplify it like

SI(Q103<>"",SI(Q103="Lunes",1,SI(OR(Q103={"Martes","Miércoles","Jueves","Viernes","Sábado"}),3,SI(Q103="Domingo","",""))),"")

 

[Toadstool]

Hi ColdGeorge

You don't have an option for the first SI when value_is_false.

It may be easier to change the first SI to =SI(Q103="","",SI(...etc.

 

[ColdGeorge]

Hi Fluff and Toadstool

Once again, thanks for your help.

Have a nice day!

ColdGeorge

 

[Fluff]

Glad we could help & thanks for the feedback.