Excel help

System
System Posts: 100,534 🤖 Admin 🤖
edited 10:31AM in AAT student discussion
I'm trying to enter a formula in excel so that if the profits are greater than 0 but less than 1500 it will calculate the figure by 10%, if not calculate the figure by 20%.
The closest i've got is by putting <1500, but then any negative figures still gets calculated.
Any help will be greatly appreciated.

Thanks in advance. :lol:

Comments

  • System
    System Posts: 100,534 🤖 Admin 🤖
    Re:Excel help

    Try the following formula. A3 is the location of the positive or negative profit.

    =IF(A3>0;IF(A3<1500;A3*0.1;A3*0.2);0)

    If this doesn't do what you are trying to achieve, then put a bit more information here and I will try to help.
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Re:Excel help

    You might find it works better with commas instead of the semi-colons though :)

    Chris
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Re:Excel help

    Fair comment. I'm using OpenOffice rather than Microsoft office and hadn't noticed that small difference! OpenOffice does all the same things as Microsoft but occasionally there are a few differences. :?

Categories

Privacy Policy