return a "" value in an IF formular

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
Click to expand...

You have posted this message to the wrong news group.
The access in this newsgroup's title refers to Microsoft Access, a
database product.

I would suggest you post to the appropriate Excel newsgroup.
 
Back
Top