If else statement in excel

I would like to write an excel formula that will get the percentage value of one column (one cell and then i drag it down...). It will set a cell to this value within a min and max range... for example, it will calculate 1% of column H, row 2, if the value is less than .49 set to .50, if the value is greater that 2.0 set to 2.0 otherwise the value is the percentage value

pseudo code:

             
  
                  if (H2*0.01)<0.49
                     value = 0.5
                  else if (H2*0.01)>2.0
                     value = 2.0
                  else 
                    value = (H2*0.01)

Open in new window

WalterRRAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nutschConnect With a Mentor Commented:
Like this?

=max(.49,min(h2*.01,2))
0
 
WalterRRAuthor Commented:
perfect , thanks
0
 
WalterRRAuthor Commented:
very prompt, concise answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.