Need help with Excel VLookup and IF functions

已完成 已发布的 6 年前 货到付款
已完成 货到付款

Trying to automate a labor union payroll and need a multipurpose spreadsheet that will work as a training tool for my staff, a replacement for hand-written and manually calculated pay, a reliable audit tool, and will also work as an illustration for our payroll service provider as we work together to automate labor union payroll with multiple pay rates, shift codes, and pay rules. I started on a worksheet that is about 80% reliable, but need help inserting "IF" functions into VLoookup formulas.

Excel

项目ID: #16388005

关于项目

17个方案 远程项目 活跃的6 年前

授予:

P0L

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.

$50 USD 在1天内
(325条评论)
7.3

有17名威客正在参与此工作的竞标,均价$113/小时

Tanmoy236

"I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with ma 更多

$40 USD 在3天内
(234条评论)
6.9
usmanhassan123

A proposal has not yet been provided

$250USD 在1天里
(72条评论)
6.2
satishtl

- Can get the formulas fixed, have expertise in formulas, lookups, if functions, summaries and pivot. - Have worked on complex solutions in Excel. - Have done complicated payroll system in Excel for a Aussie company, 更多

$40 USD 在0天内
(48条评论)
6.0
whitehorsetechn

Greeting, I have understood your Need help with Excel VLookup and IF functions task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel

$100 USD 在2天内
(13条评论)
5.2
katiewells3

I am an Australian Business Analyst with 15 years of professional experience building high level Excel solutions (including VBA / macros, PowerPivot, SQL connections etc.). I would love to take a look at your sheet and 更多

$166 USD 在3天内
(28条评论)
5.1
LeahAnson

I am an organized, experienced professional with more than fifteen years of experience. I have held titles such as Publishing Assistant, Administrative Assistant, Office Administrator, Insurance Administrator, and Gra 更多

$188 USD 在3天内
(8条评论)
3.8
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas etc. do let me know more detail in PM. thanks

$70USD 在1天里
(24条评论)
4.0
rhodelta

Experienced Excel user with office and technical background. I have a lot of experience with IF and VLOOKUP. Sounds easy enough but I'll need to see the actual spreadsheet.

$166 USD 在3天内
(5条评论)
2.6
zahidmohoboob

Dear Sir, I wish to submit my application for this job. Equipped with a Master in Financial Economics and a Bsc (hons) in Economics and Finance, I have eight years of professional experience in the field of Financi 更多

$55 USD 在3天内
(1条评论)
1.0
asadrehman654

hi, I'm interested in your project. Please send me a message so that we can discuss more. Thanks Asad

$155 USD 在3天内
(0条评论)
0.0
LeThiLan

Hello, My name is Lan. I am available right now. I can turn around quicky. I am good skills with excel formula

$88USD 在1天里
(0条评论)
0.0