Find Jobs
Hire Freelancers

Formula issue on very complicated workbook

€12-18 EUR / hour

Completed
Posted almost 7 years ago

€12-18 EUR / hour

Worksheet divided into 2 main sections: 1. Main data sheet which has the totals of all items. These items are divided into fractions (1/8) & time (00:00:00). 2. the rest of the worksheet is divided into daily sheets which lookup on main data sheet the totals, then it adds up what was used on that day and works out what is left. Formulas are complicated, so I need someone who understands formula as I'm having a formula issue. Here is an example of one of the formulas used in my workbook =IF(ISBLANK(Z141),N141,IF(ISBLANK(AA141),Z141,IF(ISBLANK(AB141),AA141,IF(ISBLANK(AC141),AB141,IF(ISBLANK(AD141),AC141,IF(ISBLANK(AD141),AD141,IF(ISBLANK(AF141),AE141,IF(ISBLANK(AG141),AF141,AG141))))))))
Project ID: 14448689

About the project

23 proposals
Remote project
Active 7 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
€16 EUR in 2 days
5.0 (270 reviews)
6.2
6.2
23 freelancers are bidding on average €14 EUR/hour for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€16 EUR in 40 days
4.9 (160 reviews)
6.8
6.8
User Avatar
Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We can do this for you quickly and with great quality as per your budget.. We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if you are unsatisfied, due to any reason, with our work. Will accept the lowest amount, you think is fair. Please do give me a shot. Awaiting your response. Thanks!
€12 EUR in 40 days
4.9 (39 reviews)
5.9
5.9
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
€16 EUR in 40 days
4.9 (114 reviews)
6.1
6.1
User Avatar
Hi, The formula that you put up in the description; is that the only formula you're having trouble with? =IF(ISBLANK(Z141),N141,IF(ISBLANK(AA141),Z141,IF(ISBLANK(AB141),AA141,IF(ISBLANK(AC141),AB141,IF(ISBLANK(AD141),AC141,IF(ISBLANK(AD141),AD141,IF(ISBLANK(AF141),AE141,IF(ISBLANK(AG141),AF141,AG141)))))))) Here are the problems: 1) =.....IF(ISBLANK(AD141),AD141,IF(ISBLANK(AF141),....... 2) =.....IF(ISBLANK(AG141),AF141,AG141)))))))) Are you sure you want to show AG141? It is blank, right? Or you want the cell to show empty (blank)? If you want it to show empty/null use this: IF(ISBLANK(AG141),AF141,"") Here's the fully corrected formula: =IF(ISBLANK(Z141),N141,IF(ISBLANK(AA141),Z141,IF(ISBLANK(AB141),AA141,IF(ISBLANK(AC141),AB141,IF(ISBLANK(AD141),AC141,IF(ISBLANK(AE141),AD141,IF(ISBLANK(AF141),AE141,IF(ISBLANK(AG141),AF141,"")))))))) If you have any more to work with, please feel free to contact me. I have intermediate level skill in Excel. I will try to help you as much as possible. This one formula is on the house, next ones are chargable.. :-) Regards, privani
€12 EUR in 10 days
4.9 (26 reviews)
5.0
5.0
User Avatar
Hi there, I am an excel expert with over 10 years experience in financial modeling on Excel. I am keen to help you with the request. Look forward to hear from you. Thanks, RRC
€12 EUR in 40 days
4.4 (15 reviews)
5.0
5.0
User Avatar
Hello. I have extensive experience in Excel, Coding and Data processing.I can do your project in less than a Day according to your description with full delivery and without error. I would also complete your project with the highest precision and quality.
€18 EUR in 4 days
5.0 (27 reviews)
4.2
4.2
User Avatar
Hi, I am CPA by qualification, having experience of more than 6 years in a reputed MNC as a Financial Analyst, having good knowledge in Accounting and well versed with various Accounting software. Regards Pooja shah
€12 EUR in 3 days
4.8 (5 reviews)
2.5
2.5
User Avatar
I am experienced in excel. I think I can help. .
€20 EUR in 2 days
5.0 (3 reviews)
2.1
2.1
User Avatar
Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of particular field. I have recently complete similar project. Thank you for your time and consideration Ram Dadhich
€12 EUR in 40 days
4.9 (7 reviews)
2.2
2.2
User Avatar
What if i can make you a vba script, which can do your task with just a click of a button. and you can add your requirement how ever you want. i can implement that complex logic. But all you need to do is , you have to make me understand you requirement clearly. This may take your time in chatting with me.
€13 EUR in 40 days
5.0 (1 review)
1.4
1.4
User Avatar
Dear client, I have understood your project and I hope I seriously complete your jobs.I can make anything you want, if you can describe exactly what you want, will get the exact service until full satisfaction . Best Regards, Kamruzzaman
€13 EUR in 40 days
5.0 (3 reviews)
1.2
1.2
User Avatar
Hello there, I want to take a minute of your time for reading my message. If ever you need a virtual assistant for any other projects please let me know. I am kinda looking for a job right now. I apologized for bothering you. Have a great day ahead :)
€16 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i WOULD LIKE TO HELP YOU IN SOLVING THE ISSUE. I COULD CHECK THE EXCEL DOCUMENT AND TRY MY BEST CORRECT IT FOR YOU. I WOULD SHARE MY MAIL ID TO WHICH YOU CAN SNED THE EXCEL DOC. HOPE TO MAKE THIS RIGHT, REGARDS! THOMAS JOSE
€12 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have found some mistakes in formulas. .
€12 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
this is the easy job i take a look at you test file you have to much formulas but they are not complicated
€12 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€14 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€16 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of IRELAND
Bray, Co. Wicklow, Ireland
5.0
4
Payment method verified
Member since Sep 28, 2016

Client Verification

Other jobs from this client

I need to work out formula
€12-18 EUR
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.