How to display a '0' value as "Nil"

[Angelena]

If my calculated value = 0, I need the cell to say "NIL". If it is any value other than 0, then it has to be that calculated number. How can I do this?

Thanks in advance!

[bentleybob]

=IF (formula=0,"NIL",formula)

[NBVC]

You can format the cells to show that.

Select the cells, right-click and select Format Cells. In the Number tab select Custom and enter: 0;-0;"Nil";@ in the type field.

[Angelena]

NBVC: So if I need the numbers to be in the Accounting format with two decimal places, how do I add that on to the custom format you gave me? Thank you so much!

[NBVC]

The easiest way is to go to Number tab, select Accounting, and play with the decimals and any symbol you want, then select Custom, this should show the code for the Accounting you selected... just replace the portion between the 3rd and 4th semicolons with "Nil"

[Angelena]

THANKS NBVC!!!! That worked.