• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If function

Ufoo

Member
Hello experts,

Please excuse my naivety. I am struggling with IF function. I want this formula (=IF(C6:C20=C6,IF(E6:E20="marejesho",F6:F20,"")) to return null empty string ("") if the condition is false. I do not want false ({"";"";1500000;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}). What am I doing wrongly please? Thanks
 
=IF(C6:C20=C6,IF(E6:E20="marejesho",F6:F20,""),"")

You probably should also be using Ctrl+Shift+Enter instead of simply Enter

If that doesn't help please post the file and describe what you are trying to achieve
 
You can try to use AND function as well (normally entered)
=IF(AND(COUNTIF(C6:C20,C6)=15,COUNTIF(E6:E20,"marejesho")=15,COUNTBLANK(F6:F20)=15),"Your Text","")
 
It maybe a 2 criteria lookup, try…….

1] {=SUM(IF(C6:C20=C6,IF(E6:E20="marejesho",F6:F20,"")))}

or

2] =SUMPRODUCT((C6:C20=C6)*(E6:E20="marejesho"),F6:F20)

Regards
Bosco
 
=IF(C6:C20=C6,IF(E6:E20="marejesho",F6:F20,""),"")

You probably should also be using Ctrl+Shift+Enter instead of simply Enter

If that doesn't help please post the file and describe what you are trying to achieve
It works @Hui. Thanks
 
Back
Top