Find Jobs
Hire Freelancers

Fix my excel formula

$10-30 AUD

Completed
Posted over 3 years ago

$10-30 AUD

Paid on delivery
Please fix the formula in my excel sheet attached. Refer to attached PDF and work on attached excel sheet. Details of how I want the formula to work: (1) If 7B = >0 then 30F = 0. But (2) If 7B = 0 then cell 30F = average $/sqm (column R) of "s" (column P) (level 2) But (3) If there is no "s" in column P I want cell 30F to be "-" I have the formula working for points 1 and 2 however not 3. If you can incorporate point 3 that'd be great.
Project ID: 27961104

About the project

16 proposals
Remote project
Active 3 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
Hi, yes this is possible. I would like to clarify few things about the formulas. I believe i can help you with this in matter of minutes. I've completed hundreds of excel projects without a single problem. Thanks, Milan
$15 AUD in 1 day
5.0 (564 reviews)
7.2
7.2
16 freelancers are bidding on average $19 AUD for this job
User Avatar
Hi, I have updated formula in a cell F30 already. I will send an updated file immediately. Would be great to hear from you, Duong
$10 AUD in 1 day
4.9 (46 reviews)
6.4
6.4
User Avatar
Hi there I would love to help you with the correction of excel formulas. I'm well versed with Excel VBA/Macro, complex formulas, pivot tables, etc. Quality and work accuracy is my first priority. Hope to hear from you soon. Thanks
$15 AUD in 1 day
5.0 (23 reviews)
5.9
5.9
User Avatar
hi, I have checked you spreadsheet and I can help you with the formula. Just message me and will share it with you. Thanks!
$15 AUD in 1 day
4.9 (38 reviews)
4.9
4.9
User Avatar
Hi there, Want you need is a formula that will check if there is "s" in Colum to return "-" in F30 otherwise return the result from the 1st two formulas? Please message me if this is any of what you need. I'll be standing by to help. -Reggie
$15 AUD in 1 day
5.0 (25 reviews)
4.9
4.9
User Avatar
Hy I am an excel Expert and I can do this perfectly. I can do accordingly. let have a chat for more discussion. thanks
$35 AUD in 1 day
4.9 (8 reviews)
4.2
4.2
User Avatar
Hi I can develop any complex formula in Excel and Excel VBA I understood your logic requirement with IF statement It can be done in few minutes Pls contact me to start the work and complete in few minutes Waiting for your reply Regards,
$20 AUD in 1 day
5.0 (14 reviews)
3.9
3.9
User Avatar
Hi there, I can do your project with 100% accuracy. I have reviewed your "Fix my excel formula" project brief carefully and would like to assist you with the task. Please check via this link what are the my clients said about my previous works (reviews) - https://www.freelancer.com/u/jnpkfb I have no project in my hand so that I can start your project right now. I work efficiently and will finish in a timely manner and will provide high quality work. If you need any sample please let me know. I am waiting to your quick positive reply and if you have any questions, feel free to ask me. Thanks! K P Janaka
$15 AUD in 1 day
5.0 (11 reviews)
2.6
2.6
User Avatar
Hi, I have fixed the formula. Can share proof with you on chat. Now if there is no 'S' in Column P then cell F30 will show '-'. Looking forward to working with you.
$20 AUD in 1 day
5.0 (1 review)
1.9
1.9
User Avatar
I am a professional in Excel formulae and had worked extensively on excel sheets for various institutions in India.
$18 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hlo sir. my name is ARYAN I can provide you better support on social media because I have experience of doing social media marketing and I can serve you better. See I know sir I am new in freelancing site but work with me once you will definitely come again to my page thank-you it's my number contact me 98-03-79-36-8 EIGHT
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am mathematician and have a good statistical finiancial skills on excel. Now i work in a bank as market risk manager, lets see your task and send me your task description. =IF(B7>0,0,IF(B7=0,AVERAGEIFS(R8:R17,P8:P17,"S"),"-")) it is the formula you looking for
$30 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. The fix is quick it will not take more than 1 hour. let me know if you wish to connect for the same. Hope to give you quick solution.
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
4
Payment method verified
Member since Sep 25, 2020

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.