G
Guest
Any help greatly appreciated with this: I have two formulars that work, but I
want them to return "" or nothing when nothing is in cell 012. The formulars
are:
=IF(O12>O11,"End milestone deadline passed","OK")
=IF(AND(O12>O11,OR(D12>D11,E12>E11,F12>F11,G12>G11,H12>H11,I12>I11,J12>J11,K12>K11,L12>L11,M12>M11,N12>N11)),"End
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
OK")
Apologies if you have already replied to this B4, as I have posted it today
can could not track where it was.
want them to return "" or nothing when nothing is in cell 012. The formulars
are:
=IF(O12>O11,"End milestone deadline passed","OK")
=IF(AND(O12>O11,OR(D12>D11,E12>E11,F12>F11,G12>G11,H12>H11,I12>I11,J12>J11,K12>K11,L12>L11,M12>M11,N12>N11)),"End
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
OK")
Apologies if you have already replied to this B4, as I have posted it today
can could not track where it was.