Enter formula only if a cell does not contain specific text

In a nut shell what I am trying to do is this.

If cell B5 contains the text On-Going then in cell E5 should contain "N\A" if anything else then cell E5 should contain the following formula

Formula:

Please Login or Register  to view this content.

What I have tried to do so far has not worked, formula listed below.

Formula:

Please Login or Register  to view this content.

This produces the standard...."The formula you typed contains an error" message in Excel

I also tried this

Formula:

Please Login or Register  to view this content.

which gives me the N\A but only gives the text of the formula, not the actual formula!! (no brainer there, but I had to try it )

Any help would be appreciated.

Thank You

you can make you "and" statement look like this. if(AND(d5>=c5,c5>0,d5>0),networkdays..... this statement means that all of it must result in a true answer. but im not sure what is going on in the the ,NETWORKDAYS(C5,D5) what is the c5,d5?? are you adding..
if you can upload a sample sheet

Try it without the = in the middle, like this:

=IF(B5="On-Going","N\A",IF(D5>=C5,IF(AND(C5>0,D5>0),NETWORKDAYS(C5,D5),""),""))

Hope this helps.

Pete

Pete and Ace_XL - Awesome, thank you so much, I knew I was missing something trivial here!! SOLVED