I am trying to use the INDEX function. However, certain cells are blank and when indexed return zeroes. Is there anyway I can have it return a blank cell?
Thank you!
I am trying to use the INDEX function. However, certain cells are blank and when indexed return zeroes. Is there anyway I can have it return a blank cell?
Thank you!
This should do it!
=IF(INDEX(range,row,column)=0,"",INDEX(range,row,column))
Thanks!
Mr.WalterJones,
There are many ways you can do that. Three suggestions are:
1) Use a custom format to make 0's show as blanks. To do so, select the range of Index Results -> Right-click and select Format Cells -> Custom -> Type "0; ; " (no quotes, that's Zero Semicolon Space Semicolon Space) -> OK
2) Use conditional formatting to make 0's show as blanks. To do so, select the range of Index Results -> Conditional Formatting -> Highlight Cells Rules -> Equal To... -> Type 0 and select Custom Format from the dropdown list -> Go tot he Number tab -> Custom -> Type "0; ; " (no quotes) -> OK
3) Incorporate a check into the formula.
=IF(INDEX(A1:A10,3)=0,"",INDEX(A1:A10,3))
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
YOU GUYS ARE THE BEST!
TIGER YOU ARE A G, THAT'S A G FOR GANGSTA! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks