Attaching a sample workbook would be best to obtain more in-depth help.
Based on what you have posted, however, it looks like you could use a simple LOOKUP formula instead of a long IF formula. This will be more efficient. It could look like this:
=LOOKUP(A1,{1,3},{"Rent","Cable"})
If you want to return a blank cell if the criteria is not met, try:
=IFERROR(LOOKUP(A1,{1,3},{"Rent","Cable"}),"")
Just as a side note, entering in "" as a TRUE/FALSE value within an IF statement will return a blank cell.
Bookmarks