Excel 2010- in cell Y2 I need a formula that if cell x2 is blank leave blank, if J2 ="crude" and X2 if greater than the ABS of 0.2 then cell equals Y, otherwise if X2 is greater than the abs of 0.5 then cell is equal to Y otherwise cell value is equal to N