Is it possible to combine multiple formulas in one cell? I have several employees and I want cell A1 to evaluate several factors and enter the appropriate code based on these various factors.
Here are my formulas:
=IF(AND(D7<1,C7>O1-8),"D","")
=IF(OR(E10=O35,E10=O41,E10=O47,E10=O53),"T","")
=IF(OR(E11=O$37,E11=O$43,E11=O$49,E11=O$55),"L","")
=IF(OR(E12=O36,E12=O42,E12=O48,E12=O54),"N","")
=IF(OR(E13=O$38,E13=O$44,E13=O$50,E13=O$56),"R","")
=IF(D14=0,"F","")
= IF( AND(D15 =0, OR( E15 = O39, E15 = O45, E15 = O51, E15 = O57) ), "X", "" )
Any ideas?
Bookmarks