conditionally clearing content

[rj12]

I aplogize if this should be combined with my other thread but i thought since my question changed id start a new thread.

I have 3 columns filled with formulas. All are IF statements that returns "X" for true and "" for false. Is it possible to identify the "false" cells and clear the content? I want nothing in there- no value or formula.

the range in question is J5:L100

thank you,
RJ

 

[Jonmo1]

Make the formula return 0 instead of ""

then you can highlight the range J5:L100
Press CTRL + G (edit - goto)
special
Formulas
Check Numbers only
OK
Right click any highlighted cell, clear contents.

Hope that helps.

 

[rj12]

thank you for taking the time to reply to my question.
I tried exactly as you outlined and im receiving a "no cells were found" message.

i'll list the two formulas i have running

=IF(INTEREST_RATE>0,"X","0")
=IF(AND(INTEREST_RATE=0,(DAYS360(RCVD_DATE,today)>7)),"X","0")

thanks again for the assistance.

RJ

 

[Jonmo1]

remove the quotes from the "0"

Should be

=IF(INTEREST_RATE>0,"X",0)
=IF(AND(INTEREST_RATE=0,(DAYS360(RCVD_DATE,today)>7)),"X",0)

 

[Murali1881]

Try this !

=IF(INTEREST_RATE>0,"X",0)
=IF(AND(INTEREST_RATE=0,(DAYS360(RCVD_DATE,today)>7)),"X",0)

Regards,

Murali

 

[rj12]

thank you for the assistance!! worked perfectly!