# Thread: If, And OR Formula Help

1. ## 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

2. Do you mean:
=IF(AND(B11=1;F11<>"");IF(F11<0.25;1;F11-0.25);IF(B11=2;F11,""))

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

4. Originally Posted by rory
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
•