{=IF(SUM(IF(m_code=$A9,weighted))=0,"--",MROUND(SUMPRODUCT(IF(m_code=$A9,m_base25),(IF(m_code=$A9,weighted)))/SUM(IF(m_code=$A9,weighted)),(IF(SUMPRODUCT(IF(m_code=$A9,m_base25),(IF(m_code=$A9,weighted)))/SUM(IF(m_code=$A9,weighted))>=100,1,0.5))))}

the formula works but I just want to use ROUND instead of MROUND...

Thanks!