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

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

--
macropod
[MVP - Microsoft Word]


"civilized_engr" wrote in message
...
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

Hi

For a figure in cell A1:
=(1.1+(A110000)*0.1+(A140000)*0.1)*A1

Arvi Laanemets



"civilized_engr" wrote in message
...
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)))