Forum Discussion
CS1516
Nov 09, 2021Copper Contributor
IF/AND Formula help
I have a spreadsheet which is used daily for scheduled/completed jobs. Basically, we have a scheduled row for each day of the week and how many jobs are planned for that day, and the second row shows...
HansVogelaar
Nov 09, 2021MVP
Let's say the number of scheduled jobs is in B2 and the number of completed jobs is in C2.
Use the formula =IF(B2=0,IF(C2=0,1,C2),C2/B2)
Format the cell with the formula as a percentage. It can be filled down if required.
- CS1516Nov 09, 2021Copper Contributor
HansVogelaar That seems to have worked perfectly. Thank you!