How do a create a conditional formula in Excel?

  • Thread starter Thread starter Danno
  • Start date Start date
D

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?
 
=IF(D4="","",MAX(MIN(30,D4),0))

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

in E4 put this formula
=IF(D4>30,30,IF(D4<0,0,IF(AND(D4>=0,D4<=30),D4,"")))
 
perhaps you should look up "IF" in Excel Help, and review the examples
provided. That will help you understand the way to do it.
 
Thanks a bunch guys! All of them work great so I'll just use the simplest
form. Thanks John!
 
Back
Top