Modify a Formula to Display Blank

carl · 09-06-2005, 03:05 PM

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 · 09-06-2005, 10:05 AM

Try this

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

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
>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 · 09-06-2005, 12:05 PM

Try this

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

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
>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 · 09-06-2005, 03:05 AM

Try this

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

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
>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 · 09-06-2005, 03:05 PM

Try this

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

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
>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.

Anne Troy · 09-06-2005, 10:05 AM

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

www.OfficeArticles.com

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
> 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.

Anne Troy · 09-06-2005, 03:05 PM

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

www.OfficeArticles.com

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
> 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.

Anne Troy · 09-06-2005, 12:05 PM

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

www.OfficeArticles.com

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
> 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.

Anne Troy · 09-06-2005, 03:05 AM

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

www.OfficeArticles.com

"carl" <carl@discussions.microsoft.com> wrote in message
news:B65D1691-8DB8-415A-A823-231AEBB3033F@microsoft.com...
> 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.