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
