ExcelBanter - Modify a Formula to Display Blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Modify a Formula to Display Blank (https://www.excelbanter.com/excel-worksheet-functions/35132-modify-formula-display-blank.html)

carl

Modify a Formula to Display Blank

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"))

"carl" wrote in message
...
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

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

www.OfficeArticles.com

"carl" wrote in message
...
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.

All times are GMT +1. The time now is 03:17 PM.