Formula assistance please E2003

[Ben Dover]

Good afternoon

I have 2 columns in a worksheet that show a) on time deliveries and (b) failed deliveries both of which are totalled at the end assuming that I had 6 on time deliveries in column (a) and 4 failed deliveries in (b) how could I write a formula in another cell that could show the percentage of failed deliveries (in this case 40% because 4 out of 20 failed)

Thanks

Steve

 

[Brian from Maui]

Good afternoon

I have 2 columns in a worksheet that show a) on time deliveries and (b) failed deliveries both of which are totalled at the end assuming that I had 6 on time deliveries in column (a) and 4 failed deliveries in (b) how could I write a formula in another cell that could show the percentage of failed deliveries (in this case 40% because 4 out of 20 failed)

Thanks

Steve

=B1/A1+B1

Format as Percentage, where A1 is on time and B1 is failed

 

[NBVC]

Assuming your Total On-time is in A10 and your total Failed is in B10

=B10/(A10+B10), then format cell to Percent via FORMAT|CELLS, Number Tab.