Excel Help
System
Posts: 100,534 🤖 Admin 🤖
:twisted: 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.
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.
0
Comments
-
Re:Excel Help
I've put an answer on the other thread where you asked the same question:
http://www.aat.org.uk/forums/posts/list/0/10033.page#45058
0