So, what did you try?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
"mtate" wrote in message
...
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.