You are welcome, and thanks for the feedback.
--
John C


"Danno" wrote:

Thanks a bunch guys! All of them work great so I'll just use the simplest
form. Thanks John!

"John C" wrote:

Actually, this one is much cleaner.
=MIN(MAX(D4,0),30)
--
John C


"Danno" wrote:

I want to create a column that enters an amount automatically based on the
amount in the same row adjacent to this column. ie.) IF D430, enter 30 in
E4. and IF D4<0, enter 0 in E4, and if D4 is between 0 and 30, copy that
amount to E4. Sorry I'm so ignorant in Excel but I'm still learning. This
has to be an easy formula to create, I just don't know how. Any help out
there?