If statements

[Guest]

This must have been solved already.
I want to compare budget(cell a) and actual(cell b) columns and display a
percentage result in an adjacent cell(cell c). If either cell a or cell b is
0, I want cell c to display either: "n/a" or "0" or be blank.

 

[IC]

One way
=IF(A1=0,0,IF(B1=0,0,B1/A1))

Ian