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?

=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?

perhaps you should look up "IF" in Excel Help, and review the examples
provided. That will help you understand the way to do it.

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?

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?

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?

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?

try this

in E4 put this formula
=IF(D430,30,IF(D4<0,0,IF(AND(D4=0,D4<=30),D4,"") ))




On Oct 15, 11:49*pm, 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? *