Selesai

Formula issue on very complicated workbook

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))))))))

Keahlian: Excel

Lihat lebih lanjut: complex formula in excel example, complex excel formulas with examples, excel 2016 formulas and functions, new formulas excel 2016, excel indirect function closed workbook, excel alternative to indirect, volatile formulas, excel 2016 formulas pdf, chemical formula writing worksheet, vba excel workbook worksheet, inventory worksheet cell create formula, inventory worksheet cell create formula will, sample sign sign sheets daily work, send worksheet formula function, php script adds mathmatic formula

Tentang Pemberi kerja:
( 4 ulasan ) Bray, Co. Wicklow, Ireland

ID Proyek: #14448689

Diberikan kepada:

€16 EUR / jam
(270 Ulasan)
6.2

23 freelancer menawar dengan rata-rata €14/jam untuk pekerjaan ini

schoudhary1553

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 ex Lebih banyak

€16 EUR / jam
(160 Ulasan)
6.8
avinav606lx

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 q Lebih banyak

€16 EUR / jam
(114 Ulasan)
6.1
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 100 works on Freelancer where major Lebih banyak

€15 EUR / jam
(82 Ulasan)
5.9
ReliableMate

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 Lebih banyak

€12 EUR / jam
(39 Ulasan)
5.9
privani

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(AD14 Lebih banyak

€12 EUR / jam
(26 Ulasan)
5.0
RRconsultant

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 / jam
(15 Ulasan)
5.0
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Lebih banyak

€13 EUR / jam
(23 Ulasan)
4.3
sourabhg98

Hello, greetings for the day! I went through the sheet you attached, I see there is a lot of stuff going in there. The formula you wrote in the description simply checks each cell and if it is blank, as soon as it f Lebih banyak

€12 EUR / jam
(23 Ulasan)
4.1
younus15

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 Lebih banyak

€18 EUR / jam
(27 Ulasan)
4.2
€12 EUR / jam
(12 Ulasan)
4.0
Pmshah1985

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 / jam
(5 Ulasan)
2.5
rakshitdadhich

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 parti Lebih banyak

€12 EUR / jam
(7 Ulasan)
2.2
ScareCrow01

I am experienced in excel. I think I can help. .

€20 EUR / jam
(3 Ulasan)
2.1
sahilkwatra

Business consultant working in strategic consulting in the advanced analytics domain. During my tenure of 3 years with this firm, I've worked extensively with excel and VBA. Most of my clients are billion dollar pharma Lebih banyak

€13 EUR / jam
(2 Ulasan)
1.7
imteyazkhan85

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 t Lebih banyak

€13 EUR / jam
(1 Ulasan)
1.4
kamruzzaman36

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 . Lebih banyak

€13 EUR / jam
(3 Ulasan)
1.2
ajyothierp

A proposal has not yet been provided

€14 EUR / jam
(0 Ulasan)
0.0
thomasjose4u

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! Lebih banyak

€12 EUR / jam
(0 Ulasan)
0.0
kleosims

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 / jam
(0 Ulasan)
0.0
spOrtman023

I have found some mistakes in formulas. .

€12 EUR / jam
(0 Ulasan)
0.0