+ Reply to Thread
Results 1 to 3 of 3

IF and AND Function with 3 possibilities

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    7

    Exclamation IF and AND Function with 3 possibilities

    Hi, please help

    I need an excel formula for one cell that combines the following for a cell A3 (official working hours). This is to create a template for calculating working hours and overtime based on the type of day, with cell A1 stating the type of day and A2 listing their Time-In
    (WD=work day, or REST day or PH=Public Holiday or include MC=Medical Leave, UPL=Unpaid Leave, AL=Annual Leave, CCL=Childcare Leave, OL=Other Leaves)


    IF A2 is blank, then cell A3 would be blank
    - This is if they are on leaves or "REST" or "PH" and do not come back for work, therefore I do not want the cell to be filled at all

    IF A1=not "WD" AND A2 is not blank, then cell A3 would be "0"
    - This would count for days they are on "REST" or "PH" but come back to work, therefore official working hours cell A3 is "0"

    IF A1="WD" and A2 is not blank, then cell A3 would be "8"
    - This is for official working days and with Time-in filled

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: IF and AND Function with 3 possibilities

    Hi,

    a first attempt:


    Please Login or Register  to view this content.

    Cheers
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: IF and AND Function with 3 possibilities

    hI, tRY
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Boo?ath?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF function with multiple possibilities
    By eighcoop in forum Excel General
    Replies: 6
    Last Post: 08-15-2015, 07:44 PM
  2. [SOLVED] IF function with three different possibilities
    By kbriaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2013, 08:19 PM
  3. SUMPRODUCT Possibilities
    By calli in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-13-2007, 07:52 PM
  4. multi-function macro possibilities?
    By andysgirl8800 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2006, 10:55 PM
  5. If Function Possibilities
    By rheller in forum Excel General
    Replies: 2
    Last Post: 06-08-2005, 11:05 AM

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