Feb 06 2022 12:03 PM
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 %
Feb 06 2022 12:27 PM
SolutionFeb 07 2022 04:19 AM
Many, many thanks for your help, worked perfectly.
Feb 06 2022 12:27 PM
Solution=(H3+I3)/C3
Format the cell with the formula as a percentage. Fill down.