Results 1 to 11 of 11

Help with formatting Formula using IF statement

Threaded View

Eva10101 Help with formatting Formula... 09-26-2018, 07:26 AM
Tsjallie Re: Help with formatting... 09-26-2018, 08:34 AM
Eva10101 Re: Help with formatting... 09-26-2018, 09:36 AM
Tsjallie Re: Help with formatting... 09-26-2018, 02:15 PM
Eva10101 Re: Help with formatting... 09-26-2018, 09:25 AM
Eva10101 Re: Help with formatting... 09-27-2018, 06:39 AM
Tsjallie Re: Help with formatting... 09-27-2018, 07:12 AM
Eva10101 Re: Help with formatting... 09-27-2018, 08:47 AM
Tsjallie Re: Help with formatting... 09-27-2018, 02:30 PM
Eva10101 Re: Help with formatting... 10-02-2018, 07:04 AM
Tsjallie Re: Help with formatting... 10-02-2018, 01:56 PM
  1. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Help with formatting Formula using IF statement

    Not sure what yr workbook looks like, but I assume there will be some kind of table holding the hours worked of employees per month.
    The attached sample shows some formulas using IF to calculate what you need (as far as I understand).
    Attached Files Attached Files
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF statement clause and SUMIF statement formula help!!!!
    By djmatok in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 10-28-2015, 04:48 PM
  2. [SOLVED] Conditional formatting with an AND statement
    By trisoldee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2014, 02:23 PM
  3. [SOLVED] VBA If Statement Formatting
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-19-2014, 11:32 AM
  4. [SOLVED] Formula for Income Statement in financial statement
    By Zunit in forum Excel General
    Replies: 6
    Last Post: 07-02-2012, 02:21 PM
  5. IF statement using formatting criteria (NOT conditional formatting)
    By chelseasikoebs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2009, 01:57 AM
  6. Conditional Formatting statement
    By thomas.szwed.uk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2008, 10:23 AM
  7. =IF Statement formula or conditional formatting
    By Abi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1