SOLVED

Excel percentage calculation

Copper Contributor

I am attempting to work out the conversion rate of calls taken to sales achieved as a %, ie 10 calls and 6 sales = ? as a %. ( I have 3 columns C,(calls) H(a specific item) & I( anoth specific item), so the calculation should be C-(H+I), right ? and then that answer should be a %Excel Sheet.jpg

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Dave_Rankinfuzzy12 

=(H3+I3)/C3

 

Format the cell with the formula as a percentage. Fill down.

Many, many thanks for your help, worked perfectly.

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Dave_Rankinfuzzy12 

=(H3+I3)/C3

 

Format the cell with the formula as a percentage. Fill down.

View solution in original post