Delivery performance formula query

Good morning all
I am trying to put what I thought would be a simple Excel table together to show whether our suppliers are hitting/missing deliveries against a set target by week number. I have so far got the following but would like to show 0 in the performance column (F) when no deliveries are made, 100 if all deliveries are hit then a percentage if any are missed v total made. I know it is going to be something easy but for the life of me I can't work out how to do this, or if I have made the whole formula itself too complicated and can be more simple. I am also showing this data in a chart which will look skewed if it shows 100% on time if no actual deliveries were made.
I've attached the spreadsheet with the table and chart, would it be possible to point me in the right direction please to show actual figures please

Any help you can offer on this would be really appreciated

Week No. (Column A)
Deliveries Hit (Column B)
Deliveries Missed (Column C)
Total Deliveries (Column D)
Target % (Column E)
Performance % (Column F)

=IF(ISERROR((B3/C3)/D3),"100",(B3/C3)/D3)

Week No. Deliveries Hit Deliveries Missed Total Deliveries Target % Performance %
1 0 0 0 95 100
2 0 0 0 95 100
3 1 0 1 95 100
4 0 0 0 95 100
5 1 0 1 95 100
6 0 0 0 95 100
7 3 0 3 95 100
8 0 0 0 95 100
9 0 0 0 95 100
10 0 0 0 95 100
11 0 0 0 95 100
12 1 0 1 95 100
13 0 0 0 95 100
14 1 1 2 95 50%

Hi and welcome
does this help =IF(D3=0;0;IFERROR(B3/C3/D3;100))

Hello Pepe
Thanks so much for your quick response on this, it is really appreciated
Unfortunately, when I type in your formula above, I get a problem box pop up querying whether I want to type a formula or not. It looks fine to me but for some reasons Excel thinks something is missing, any thoughts as to why it might not like it?

BR,
James

Ah yes, my bad. Try =IF(D3=0,0,IFERROR(B3/C3/D3,100))
I forgot to replace the semi colons with commas

Hi Pepe

Thanks so much and so sorry for my delay in saying thank you. I changed the last part to say 1 instead of 100 as it was giving me 10000% but everything else is great.

Really appreciate your support on helping me with this

BR,
James