IF function

M

mtate

I have a column called HOUR that contains numbers from 0 to 23. I am trying
to create a formula that with populate another column called called SHIFT
with the following:

Shift should = D if HOUR is 7 thru 18
Shift should = N if HOUR is 0 thru 6 or 20, 21, 22, 23

I was using the IF function. I know this should be simple, but can't get it
to work for all.
 
M

mtate

=IF(J43>=7,"D",IF(J43>20,"D","N"))
Everything shows up as D, even values over 20 and from 0 to 6.
 
S

Sandy Mann

Shift should = D if HOUR is 7 thru 18

You don't say what you want if Hour is 19 so assuming that you want Shift to
be N then try:

=IF(MOD(J43*7,133)>48,"D","N")

HTH

Sandy
 
Top