| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| would like to know the formula amount and display word | Excel Discussion (Misc queries) | |||
| Modify A SumProduct Formula | Excel Worksheet Functions | |||
| Modifying a Formula To display only Unique Values | Excel Worksheet Functions | |||
| Help with formula to make cell blank | Excel Worksheet Functions | |||
| Display excel formula on worksheet | Excel Worksheet Functions | |||
Linear Mode
