percentage formula

[ch1981]

Hi

If i have the below information how would i work out the daily despatch percentage using this?

orders despatched - 88
orders not despatched -13

Thanks

[The_Snook]

Hi ch1981,

It's the orders despatched value (88) divided by the total number of orders (88+13=101). So the daily despatch % is 87.1% (88/101*100).

In Excel terms it's =A1/(A1+A2) and apply the percentage cell format.

Where A1 is the cell reference for the orders despatched number and A2 the cell reference for orders not despatched.

Hope this helps,

Snook

[forestview]

If A1 = 88 A2=13

=A1/(A1+A2) and set as % on Home Tab