How do a create a conditional formula in Excel?

[Danno]

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 D4>30, 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?

 

[John C]

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

This assumes that D4 is either blank, or will have a number in it.

 

[muddan madhu]

try this

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

 

[Bob I]

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

 

[John C]

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

 

[Danno]

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

 

[John C]

You are welcome, and thanks for the feedback.