Setting some rules on google sheet so it calculates simple average
- or -
Post a project like this2258
$25
- Posted:
- Proposals: 1
- Remote
- #1854564
- Completed
Description
Experience Level: Intermediate
Industry: Business
Description of excel work: Using Google Sheets in the Google Drive want to create simple rules
I want to track simple averages. Example:
25 people walked by front door of business, staffer registered 5 = 20% success
My employee makes 20 calls during their shift and talks to 10 people = 50% success
My employee texts 40 people during their shift and 10 people reply - 25% success
My employee emails 30 people during their shift and 15 people replied = 50% success.
Could you set math formula to calculate this percentage (see attachment, its all color coordinated)
Extra notes: there are only 4 math functions in this spreadsheet
1. ) Met at front door to Number of Registrations - what is the ratio or percentage (in pink)
2. ) Phone Calls Made to People actually talked to on the phone - what is the ratio or percentage (green)
3. ) Number of Texts to People Replying to these Texts - what is the ratio or percentage (yellow)
4. ) Number of Emails to People Replying to these Emails - what is the ratio or percentage (blue)
Description of excel work: Using Google Sheets in the Google Drive want to create simple rules
I want to track simple averages. Example:
25 people walked by front door of business, staffer registered 5 = 20% success
My employee makes 20 calls during their shift and talks to 10 people = 50% success
My employee texts 40 people during their shift and 10 people reply - 25% success
My employee emails 30 people during their shift and 15 people replied = 50% success.
Could you set math formula to calculate this percentage (see attachment, its all color coordinated)
Extra notes: there are only 4 math functions in this spreadsheet
1. ) Met at front door to Number of Registrations - what is the ratio or percentage (in pink)
2. ) Phone Calls Made to People actually talked to on the phone - what is the ratio or percentage (green)
3. ) Number of Texts to People Replying to these Texts - what is the ratio or percentage (yellow)
4. ) Number of Emails to People Replying to these Emails - what is the ratio or percentage (blue)
Jon L.
100% (22)Projects Completed
14
Freelancers worked with
13
Projects awarded
50%
Last project
15 Jan 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies