Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-07-2017, 04:27 AM
Ylli Ylli is offline Formula needed; I'm helpless Windows 7 64bit Formula needed; I'm helpless Office 2010 64bit
Novice
Formula needed; I'm helpless
 
Join Date: Dec 2017
Posts: 5
Ylli is on a distinguished road
Default Formula needed; I'm helpless

Hello everyone



I've uploaded an Excel file where I need some professional help.. Unfortunately in the german msofficeforums I couldn't receive an account verification email and couldn't contact an Administrator either so here I am.

What I need:

In the Excel file you can see "Total Rückerstattungen", These are the fields where the formulas belong. The formula must be able to calculate refunds. One refund is:

Being away from work over lunch, dinner and over night
Being away from work over dinner, over night and over lunch the next day
Being away from work over night and over lunch, dinner the next day

So you always have 3 possibilities, either you miss all 3 (row 24, 25, 26) on one day, or 26 the day before and 25, 26 the next day and so on.. I've included comments in the file itself so it's easier to understand.

The refund is always bound to being away over night + 2 Meals, so the formula itself should refer to the field under "night" (row 26)

If anybody could help me, I'd be really thankful as I have no idea where to start and what to do...

If you have questions please ask. I'm not sure if I explained good enough.
Attached Files
File Type: xlsx Vorlage Präsenzerefassung 2018.xlsx (283.3 KB, 14 views)
Reply With Quote
 

Tags
complicated, formula, needed



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula needed; I'm helpless Help needed with IF formula with a Vlookup jonnie_rc Excel 6 08-31-2017 01:27 PM
Formula needed; I'm helpless hard formula needed nfsmith Excel 6 03-19-2016 06:12 PM
Formula needed; I'm helpless Formula help needed Cosmo Excel 1 08-23-2012 11:50 AM
Very simple formula needed! nicholes Excel 4 04-12-2012 08:28 AM
Excel formula needed. Rod Excel 1 08-03-2009 06:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft