MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 97 - conditional

Posted by George on September 09, 2000 7:55 AM

When a cell contains a computed positive value, how do I replace it with a blank? I only want to see negative values.

The cell contains this formula:


Posted by Ivan Moala on September 09, 0100 4:29 PM

Via formula you could try;

or via formatting
Format / Cells / Number / Custom => then enter