How do a create a conditional formula in Excel?
 

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?

How do a create a conditional formula in Excel?
 

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

How do a create a conditional formula in Excel?
 

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

How do a create a conditional formula in Excel?
 

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?

How do a create a conditional formula in Excel?
 

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?

How do a create a conditional formula in Excel?
 

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?

How do a create a conditional formula in Excel?
 

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?