If statements
 

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.

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

Ian

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