I currently have IF Formulas in 3 columns across the page. The formulas return a blank ("") in 2 of the 3 cells in each row. I want to have one final column at the end which returns the information contained in the one cell that returns text.
A B C D
I would want D1 to return "Red", D2 to return "Green" and D3 to return "Blue." Remember that the "blank" cells are not actually blank- they just contain formulas that are set to return a blank cell if certain conditions aren't met.
Any help would be appreciated as to how the formulas in cells D1, D2 & D3 should look to get the results I am looking for.