FROGGER24
Well-known Member
- Joined
- May 22, 2004
- Messages
- 704
- Office Version
- 2013
- 2010
- Platform
- Windows
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