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