=IF(D4="","",MAX(MIN(30,D4),0))

This assumes that D4 is either blank, or will have a number in it.
--
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?