Excel: How do I Display Specific Text in a Cell if the Value is 0

[Peter Dam]

I use in Excel the formula =NETWORKDAYS(A2 ;B2)for calculating the number of days between the dates in cells A2 and B2. The result is in Cell C2
However, I would like to display a Predifined Text in C2 if the result is zero.

I suppose The Predifined Text can be in the formula bar in a sort of If statement.
If 0 ,OK will be displayed in cell C2)
It does not matter what in the cell will be displayed if result is not zero.

I assume the cell C2 format must then be Text or General
Normally I use Number for C2.

May be, I also can or need to use an other formula?? DateDiff or something like that?? I do not know all possibilities.

Who can help me

[Rabbit]

Sounds like you're looking for the IF() function

[Mariostg]

=if(NETWORKDAYS(A2;B2)=0,"OK",NETWORKDAYS(A2;B2))

[NeoPa]

This can be done as a simple Format property. Something like :

0;-0;"Some text"

The format property can be found in the Properties window of cells, rows and/or columns, etc.

PS. @Mario. There is no worksheet function IIF() in Excel. IF() has the same use as IIf() does in VBA though.

[Mariostg]

@NeoPa. I am doing to much VBA, I have to go back to spreadsheets. I would have never thought of your answer. Love it.

[NeoPa]

Thanks Mario. I always appreciate the support of you guys who do so much to keep things going here :-)

NB. It's important to understand that the underlying data doesn't change. It's still a zero. All that changes is what is displayed (IE. The .Text property as opposed to the .Value).

[Peter Dam]

I have tried this, but I can not get it working.
I noted that thereis an IF statement

IF(logical_test[value_if_tue];[value_if_false])

But I do not know how to use this for my problem

[brentg]

see Mariostg reply and enter :

=IF(NETWORKDAYS(A2;B2)=0,"OK",NETWORKDAYS(A2;B2)

in cell C2. It should work. Then just copy the formula down the column.

[NeoPa]

Peter Dam:
I have tried this, but I can not get it working.

You've tried what? In the circumstances (the thread to date) this makes little sense.

NB. Please read all the replies. You could save wasting much of your time (and ours of course).