using logical functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi

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

Arvi Laanemets
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookups and ifs! 2
Proportional | cumulative sum of bonus 3
If Satement formula 5
Conditional Formatting 1
How to use conditons within a LOOKUP function? 6
Lookup ? 4
Calc Speed & Formula simplification 2
IF Function - Calculation not working 4

Back
Top