Return a "" value from a formular
 

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 a

=IF(O12O11,"End milestone deadline passed","OK")

=IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K12K11,L12L11,M12M11,N 12N11)),"End
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
OK")

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

=IF(isblank(O12),"",if(AND(O12O11,OR(D12D11,E12 E11,F12F11,G12G11,H12H1
1,I12I11,J12J11,K12K11,L12L11,M12M11,N12N11) ),"End
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
OK"))
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com




"Gus" wrote in message
...
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 a

=IF(O12O11,"End milestone deadline passed","OK")


=IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K
12K11,L12L11,M12M11,N12N11)),"End
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
OK")

one way is
=if(O12="","",your equation)

"Gus" wrote:

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 a

=IF(O12O11,"End milestone deadline passed","OK")

=IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K12K11,L12L11,M12M11,N 12N11)),"End
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
OK")

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

"bj" wrote:

one way is
=if(O12="","",your equation)

"Gus" wrote:

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 a

=IF(O12O11,"End milestone deadline passed","OK")

=IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K12K11,L12L11,M12M11,N 12N11)),"End
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
OK")