the formula is like the following: =if(f2="1","Monday", If(f2="2", "Thursday", if(f2="3", "Peaches", if(f2="4", "pears",F2))))
some cells return the true value - Monday, Thursday, Peaches, pears or F2
other cells return the formula - as if it were text.
If I change the formula in a cell that worked (pears becomes Asteriods), then only the formula is displayed.
This is excel 2013, any suggestions?
thanks
Bookmarks