Modify a Formula to Display Blank

[carl]

I use this formula:

=IF(Sheet2!C5=0;"Sell";"Buy")

if Sheet2!C5 is #N/A I would like the formula to return a blank. Is it
possible ?

Thank you in advance.

 

[Barb Reinhardt]

Try this

=IF(ISNA(Sheet2!C5)=TRUE,"",IF(Sheet2!C5=0,"Sell","Buy"))

 

[Anne Troy]

=IF(ISBLANK(SHEET2!C5),"",IF(SHEET2!C5-0,"Sell","Buy"))
*******************
~Anne Troy

www.OfficeArticles.com