Help needed! IF, SUMIFS, INDEX-MATCH or anything else???

[muraterguden]

Hi all,

I have a payroll file made with several sheets. I store almost all data in the sheet I named Main DB. In this sheet mostly the working hours and some other attendance exceptions are calculated and converted to 0:00 time format. Then in other sheets dedicated to each month, the relevant info is extracted then the Gross and Net pay calculations are done.

One of those exceptions mentioned above is the Maternity Leave (Letter M is used for coding as shown in Image 1). By local laws, employer must pay 98 days wage to the employee if qualified. The first 42 of 98 days must be paid in full (pay for 8 hours work) and the remaining days in half (pay for 8 hours work).

Image 1

https://drive.google.com/file/d/0B5s...ew?usp=sharing

Normally, I subtract 2 different employee contributions (named NIS and H/S) for social security from the Gross to find the Net pay. (See the Image 2) However, if employee has a Gross pay generated from Maternity code "M", I do not deduct those employee contributions and pay the whole Gross.

Image 2

https://drive.google.com/file/d/0B5s...ew?usp=sharing

I need a function to return $0:00 for the NIS value of the days marked with "M"

For now, my NIS calculation is just a LOOKUP which looks for the Gross value in a table stored in another worksheet. I need some expert touch at this point.

Thank you all in advance.

[Pepe Le Mokko]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.msofficeforums.com/excel/...-anything.html

[muraterguden]

Hi
Thanks for your concern. Apologies if I offended your forum rules.
However I do not intend to waste anyone's time. I posted this issue in a site I am member of and didn't get a reply for few days. This is something I need to resolve quickly so I posted the same txt body on 3 other sites, hoping to get faster solution.
I do not see anything wrong with it and I do not like to be treated like a spammer either.
Murat

[Pepe Le Mokko]

Reading the indicated link referred to in red font would have spared you some frustration I think.

Excerpt :

"So What's the Big Deal?
First, let me make it clear that neither I, nor the person who pointed you here, has an issue with cross posting, so long as it is done correctly. If you feel that you get more experts pointed to your posts, then fine. What we are asking for, however, is the courtesy of knowing about it. Why? Well it's kind of simple really. If you post on several boards, you have several groups of people working on the same issue, without necessarily knowing what the others are doing."

So, you see, all we ask ( and when I say "we" I mean every forum I know of) is that you insert links to your other posts to avoid people loosing time. After all, you get FREE help here from people working for FREE on their spare time, don't you?

Please add links to the other sites - Thx

[muraterguden]

Here they are

http://www.msofficeforums.com/excel/...html#post94308
http://www.mrexcel.com/forum/excel-q...ml#post4394655
http://www.excelguru.ca/forums/showt...2031#post22031

[macropod]

Also cross-posted at: http://answertohelp.com/help-needed-...-anything-else
Where else have you cross-posted and not provided links even when asked???

[muraterguden]

macropod and all other CROSS POST COPS

I stated my case above. Nothing to do with disregarding your rules or spamming etc. Simple is that!

If this is such a big deal to all of you, state this rules at the very beginning during the registry.

Remove me from your all forums and live a peaceful life.