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:

=(F5/B5)*100


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

Via formula you could try;
=IF(((F5/B5)*100)>0,"",(F5/B5)*100)

or via formatting
Select;
Format / Cells / Number / Custom => then enter
"";-General

HTH

Ivan