help

Posted by Andrew Perry on August 26, 2001 5:12 AM

i am doing a maintenance sheet in excel 2000 when using the "IF" formula the cell shows up "TRUE" when the statment is ful-filled and "FALSE" when not. I only want to see the "TRUE" statment and a blank cell when it is "FALSE". hOW DO I HIDE THE "fALSE" statment

Posted by Barrett South London on August 26, 2001 6:29 AM

If Statm (but no FALSE is is false)

Hi there OK hould be east enough

Try on new sheet fisrt in A1 type Test

Now in say a5 paste this formula
=IF(A1="Test",TRUE,"")

Now change A1 to Hello and see the cell goes blank, not false

Hope thats OK
Good luck

Posted by Aladin Akyurek on August 26, 2001 6:41 AM

Try: =IF(condition,TRUE,"").