# Formula- If Between Add

Jan 6, 2009I am having a few issues stringing along a formula.

A1 5

I need A2 to say "If A1 is between 0 and 2 add 0, if greater than 2 but less than 4 add .30, if greater than 4 but less than 6 add .70 and so on.

A2 looking at A1

if 0 through 2 add 0

if 2 through 4 add .30

if 4 through 6 add .70

if 6 through 8 add 1

if 8 through 10 add 1.3

if 10 through 12 add 1.6

Basically these are employee break times that I need to automatically figure into our labor hours. Every 2 hours they get "x" amount of break time. So if they have over 2 hours of work they will get 1 break, if they work over 4 hours then I factor in a lunch and the previous break ect..