Hi,
Im looking for a formula for the following:
I have a row of figures, and want a formula to enable the chosen cell to tell me if its plus or minus a certian number - for example, i have a row with numbers 5, 4, 3, 4, and i want to know whether its more, less or equall to 15, the cell chosen would say "+1", or if I was wanting to know if it was more, equall or less than 20, it would say "-4"
thanks very much for any help, much appreciated