Results 1 to 3 of 3
  1. #1
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts

    If, And OR Formula Help

    I have tried this over and over but just cannot get it to work as I want it to.

    If I type a "1" in the "b" column then the times are filled out in the correct boxes from the example attached you can see that in column "I" under Mertid is any hours I work over 6 which is extra hours.
    If I type in the B column a "2" then it is overtime for all of that night (bank holidays etc) and the 6 hours is entered into the "J" column.
    What I am trying to do is add to the formula in column "I" that if I enter a "2" in the "B" column then the total hours for that day (column F) is entered in the column "I" as well as in the Overtime column.

    Thankyou in advance for any help.

    Alan
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Do you mean:
    =IF(AND(B11=1;F11<>"");IF(F11<0.25;1;F11-0.25);IF(B11=2;F11,""))
    Regards,
    Rory

    Microsoft MVP - Excel

  3. The Following User Says Thank You to rory For This Useful Post:

    AlanWade (2015-01-02)

  4. #3
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by rory View Post
    Do you mean:
    =IF(AND(B11=1;F11<>"");IF(F11<0.25;1;F11-0.25);IF(B11=2;F11,""))
    Thats what I thought I had tried but obviously not as your solution worked perfectly.
    Thankyou very much Rory.

    Regards Alan

Posting Permissions

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