Need Help In Excel formula

[brandon9990]

I'm trying to automate working out my weekly wages and i need to a wierd formula because of the way my company pays wages, basically if i work 6 hours they add 0.1 to that shift so i'm trying to add 0.1 if cell is greater than 6 i also need to take off 30 mins for break time so this is the formula i thought would work

=D4-0.5&IF(D4<6+0.1,D5)

D4 is hours worked

D5 is the output payable hours

the return i get is 7.5FALSE

[bgibbz]

17 minutes ago, brandon9990 said:

I'm trying to automate working out my weekly wages and i need to a wierd formula because of the way my company pays wages, basically if i work 6 hours they add 0.1 to that shift so i'm trying to add 0.1 if cell is greater than 6 i also need to take off 30 mins for break time so this is the formula i thought would work

=D4-0.5&IF(D4<6+0.1,D5)

D4 is hours worked

D5 is the output payable hours

the return i get is 7.5FALSE

i haven't done excel in a while, but i believe its because you are omitting the value if false part of the if statement. you are saying that if d4<6+.1 is true, then d5, but you arent specifying what to do if it isnt true.

[brandon9990]

Got it working, i din't need two formula i just needed to add the formal to the false and negative

=IF(D4>=6,D4+0.1-0.5,D4-0.5)

[brandon9990]

and if you are still interested to stop it from taking away the lunch break if i don't work that day i tweaked the formula to this =IF(D4>=6,D4+0.1-0.5,IF(D4=0,,D4-0.5))

so if hours worked is greater than 6 add 0.1 and take 0.5 but if it is less then 6 is it equal to 0 and if it is do nothing but if it isn't deduct 0.5