return a "" value in an IF formular


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.
 
Ad

Advertisements

F

fredg

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top