Thread: ordering forecast formula

Hi,

I have a slight problem with a file I'm working on.
Basically I have a file with some columns:
Sold (How many products I sold last week), Forecast (How many products that I predict to sell coming week), Stock (How much I have in stock, of the product) and Order (How much I want to order).

1. When I input a how many products I have sold into the "Sold" column, a number pops up in the "Forecast" column, this is a prediction of how many products I'm going to sell.

1. The next step is that I input how many products I have in stock.

So what I want to achieve is that once I input a number into any of the stock columns, the "Order" amount is calculated automatically.

Sold=X
Forecast=Y
Stock=Z
Order= D

So I would like to have a function (formula) like this in the "Order" column.

IF X >= Y then X-Y otherwise Y-X,
IF (X-Y or Y-X) >= Z then (X-Y or Y-X)-Z otherwise Z-(X-Y or Y-X)

Any hints and tips on how I can achieve this would be greatly appreciated.
Thanks in advance!

Thank you Palmetto, you saved my day!