Formula Question

Kit Sullivan

I am using this formula to calculate the % of budget used to date on a project:

=[Actual Hours]@row / [Planned Hours]@row. Some of our projects do not have the planned number of hours. In this case the cell for planned hours would either be 0 or NULL and I would like the % of budget cell to display: "No Planned Hours Available". I have not been able to successfully achieve this using IFERROR statement. Does anyone know how I can accomplish this?

Isis Taylor

@Kit Sullivan Try this.

=IF(OR([Planned Hours]@row = 0, ISBLANK([Planned Hours]@row)), "No Planned Hours Available", [Actual Hours]@row / [Planned Hours]@row)

Isis Taylor

@Kit Sullivan Try this.

=IF(OR([Planned Hours]@row = 0, ISBLANK([Planned Hours]@row)), "No Planned Hours Available", [Actual Hours]@row / [Planned Hours]@row)

Kit Sullivan

@Isis Taylor Thank you so much!