using logical functions

C

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
 
M

macropod

Hi civilized_engr,

=IF(A1<10000,A1*1.1,IF(A1<40000,A1*1.2,A1*1.3))

Now all you have to do is to stop building targets...

Cheers
 
A

Arvi Laanemets

Hi

For a figure in cell A1:
=(1.1+(A1>10000)*0.1+(A1>40000)*0.1)*A1

Arvi Laanemets
 
W

wmjenner

civilized_engr said:
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
Click to expand...

Try this:
=IF(A6<10000,A6*1.1,IF(AND(A6>=10000,A6<=40000),A6*1.2,IF(A6>40000,A6*1.3)))
 
Top