Use 'Conditional IF' function to set this rule.
Here's a sample statement that you would type into the cell where the result of the multiplication would be (in this case column B):
=IF(A3<501,A3*1,IF(A3<1001,A3*2))
Results:
255 255
300 300
587 1174
60 60
1005 FALSE
Now the explanation:
the 'A' column is where you have the figures for your range; e.g. 255, 300, etc.
In the example above, '<501' is a condition for the operator to multiply the figure in the column A by 1. ie. 'A3*1'
Also, '<1001' sets the condition to multiply by 2.
You can change the factors 1, 2, etc.
Take note of the bracket symbols. These are called nested functions. When the condition after the first bracket opener is satisfied, the calculation stops. Otherwise the operation moves into the next bracket, and so on.
You notice the 'false' result in the last row. This is because no factor has been set to multiply where A3 is more than 1000. So make sure that your function statement covers the maximum possible figure you will encounter.
Also, you can open more brackets (up to a max 20 - if I remember correctly). Remember, the number of bracket openers must correspond to the number of bracket closures, and all the bracket closures occur at the end of the statement.
Good luck.
