View Single Post
  #4   Report Post  
wmjenner wmjenner is offline
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by civilized_engr
in excel i want to increase the figures by 10, 20, & 30 percent respectively
for the following ranges: below 10000 = 10%, between 10000 & 40000 = 20%,
above 40000 = 30%. How do I create this logic in the if statement. I shall
aprreicate your help
Try this: =IF(A6<10000,A6*1.1,IF(AND(A6=10000,A6<=40000),A6 *1.2,IF(A640000,A6*1.3)))