Display Value as %

Daniel Barber

My company uses a formula for the Target % Complete which basically looks at the start and end dates of a task and gives the percentage of work that should have been completed to date. The formula is as follows;

=IF(Start1 <= TODAY(), IF(Finish1 <= TODAY(), 1, NETWORKDAYS(Start1, TODAY()) / INT(Duration1)), 0)

My issue is that using this formula in a new sheet gives the value as a decimal point not a percentage like in other sheets. Could someone help me understand where I am going wrong with this formula, please?

Ramzi K

Daniel, try changing the format for the cell (or column) to % format using the toolbar.

Hope that helps.

Ramzi

Daniel Barber

So simple and I completely overlooked it! Thank you!