Subtraction of cell based on condition

[Ace71425]

how do I make this statement work?

If Range("F11") = "8" And Range("N69") = 20 Then
Lunch = Range("N69") - 30
Range("N66") = Lunch
End If

 

[jasonb75]

What do you expect it to do when it is working?

A shorter version to the same effect would be

If Range("F11") = 8 And Range("N69") = 20 Then Range("N66") = -10

 

[Ace71425]

I need it where if the value of those first 2 cells match then 30 is subtracted from the current value of the third cell

 

[jasonb75]

Try

If Range("F11") = 8 And Range("N69") = 20 Then Range("N66") = Range("N66") -30

Your original code should also work if you change N69 to N66 in the second line.

 

[Ace71425]

That looks solid but it doesnt seem to be working....I have it under the worksheet change event

 

[jasonb75]

Are you changing anything in order to trigger the event?

 

[Ace71425]

Basically a user enters their hours in F11 and N69 is a field that counts how many minutes theyve worked since they opened the sheet. I need this to account for their lunch so in my example if that field N69 hits 20 after going up every minute 16,17,18,19,20 when it hits 20 if they are working 8 hours indicated in the F11 field I need the N66 to be subtracted by 30 aka their lunch

 

[jasonb75]

Does N69 hold a formula, or is it controlled by code?

Please post the formula / code as appropriate.

 

[Ace71425]

this is the formula in N69 =ROUNDDOWN(MOD(N64-N65,1)*1440,0) it is like that so I can get a whole number different between 2 date cells

 

[jasonb75]

Try using the worksheet calculate event instead of change.