Return a "" value from a formular

G

Guest

Any help greatly appreciated: I have 2 formulars that works, but I want them
to return nothing eg "" when there is nothing entered into a cell, at the
moment they return the 'false' value. My 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")
 
A

Anne Troy

=IF(isblank(O12),"",if(O12>O11,"End milestone deadline passed","OK"))

=IF(isblank(O12),"",if(AND(O12>O11,OR(D12>D11,E12>E11,F12>F11,G12>G11,H12>H1
1,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"))
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 
G

Guest

Many thanks, this worked with the 1st formular but not the 2nd. I also tried
the IF(isblank which worked for the 1st but not the 2nd
 

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

Similar Threads

return a "" value in an IF formular 1
Please help with dashes 4
Evaluating more than 30 conditions using a formula 1
Repeat formula within a cell 5
How do I continue this pattern in excel? 11
Adding numbers from other sheets? 2
Relating text to a value 5
Can't seem to get an answer to this problem. 2

Top