Modify a Formula to Display Blank

Try this

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

"carl" <[email protected]> wrote in message
news:[email protected]...
>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.

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

www.OfficeArticles.com


"carl" <[email protected]> wrote in message
news:[email protected]...
> 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.

Try this

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

"carl" <[email protected]> wrote in message
news:[email protected]...
>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.

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

www.OfficeArticles.com


"carl" <[email protected]> wrote in message
news:[email protected]...
> 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.

Try this

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

"carl" <[email protected]> wrote in message
news:[email protected]...
>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.

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

www.OfficeArticles.com


"carl" <[email protected]> wrote in message
news:[email protected]...
> 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.

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.

Try this

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

"carl" <[email protected]> wrote in message
news:[email protected]...
>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.

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

www.OfficeArticles.com


"carl" <[email protected]> wrote in message
news:[email protected]...
> 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.