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. |
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 |