Find Jobs
Hire Freelancers

Excel formulas formatting if statement

$15-25 USD / hour

Completed
Posted about 9 years ago

$15-25 USD / hour

I am in some need of formula help – can you assist? Total Call Score should be a percentage… Having said that: I set Data Validation up (data tab) so that QC can only choose: 10, N/A, or FAIL. (Maybe that needs to change, just trying to limit input) In the Fail/10 situation it works fine to build a formula, =b23/100 – the thing I need help with is how to calculate the N/A out of the equation. Would an “IF” statement work in this situation? Lastly I want Total Call Score to be a combination of: First Party, Call Scoring Bonus, Third Party Score Please let me know if you can help me create something that will work
Project ID: 7238858

About the project

18 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in a reputed Power Plant in India. Data Integration and Compilation is my prime job over there. Making reports in Excel and Powerpoint is my routine job, which gives me an edge to carry out the project. I am a new Freelancer so I have the earnest desire to carry out the project successfully. So please consider my proposal and give me a chance to boom in the market of Freelancer. Kindly contact me for further details. Thanks and Regards Tonmoy Roy Electrical Engineer
$16 USD in 3 days
5.0 (10 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$22 USD in 3 days
0.0 (0 reviews)
0.0
0.0
18 freelancers are bidding on average $19 USD/hour for this job
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. We can discuss the budget post discussing the complete requirements. Lets discuss more online on chat. Thanks, Abhinav
$26 USD in 3 days
4.9 (95 reviews)
6.0
6.0
User Avatar
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$25 USD in 2 days
4.9 (39 reviews)
5.0
5.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$16 USD in 5 days
4.9 (33 reviews)
4.8
4.8
User Avatar
A proposal has not yet been provided
$20 USD in 2 days
5.0 (15 reviews)
4.8
4.8
User Avatar
Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Feel free to message me with your actual data. Thank you.
$25 USD in 3 days
5.0 (15 reviews)
3.7
3.7
User Avatar
Hi, I am good at excel and macros... Can we have discussion about the project to start the work immediately. Looking forward for your reply to start the work on immediately. Thank you
$15 USD in 2 days
5.0 (7 reviews)
2.8
2.8
User Avatar
Dear Employer, Good morning, I am interested in this job as I have over 18 years of experience in the field of MS excel & VBA programming, data-entry and My goals are to make the employer/ customer happy and give better quality of work and I am ready to dedicate time for this project. Please Evaluate my profile and provide the data to be processed and full details so that I can automate the process and speed up delivery with 100% accuracy Needs some more details Please PM me I can give formula as you desire Thank you Kind regards BRS
$22 USD in 3 days
5.0 (4 reviews)
2.6
2.6
User Avatar
Hello. =b23/100 - it works fine, even N/A presents in cells above b23. I do not understand what's wrong. But I think, I could helpful for you. I have a great experience in Excel (10 years of job in sales department in energy company). Sure, we will solve all problems wery quickly. Just contact me and explain the problem by other words :-)
$15 USD in 1 day
5.0 (1 review)
1.1
1.1
User Avatar
A proposal has not yet been provided
$16 USD in 1 day
4.0 (1 review)
1.2
1.2
User Avatar
A proposal has not yet been provided
$15 USD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
hello sir I am interested in your project...please give me the detail instruction...i will work for your satisfaction
$15 USD in 5 days
5.0 (2 reviews)
0.0
0.0
User Avatar
I have extensive experience with Excel calculations and formulas and can help you with your work. If you can send me the file, I can solve your formula problems for 15 USD (1 hour of work). Please contact me for more information.
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i need this job because i have done this job and i can work on time .. hope you will hire me as soon as possible
$15 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
MS Excel expert with over 6 years of professional exposure to MS Excel, MS Access, SQL. I invite you to discuss further details about this project. Thank you in advance.
$27 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Eden Prairie, United States
4.5
45
Payment method verified
Member since Jan 14, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.