Forum Discussion
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...
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.
HansVogelaar That seems to have worked perfectly. Thank you!
