I am very new to using excel and am trying to create a spreadsheet to keep track of my Christmas spending.

I have a table with names, items bought, cost, cost last year, and difference between the 2 years.

I want to work out the difference between the cost this year and last year and so have used =IMSUB(C2,F2) which gives a result. If the result is negative then obviously that is shown using the negative sign. I would like to be able to show the positive sign as well though and for the life of me cannot work out how to do that.

I also want to format the cells so they show a £ but nothing I do in the formatting makes any difference to the way the results look.

Lastly I want to add up the results of the difference column but as some of the numbers are negative the results don't' appear to work.

Any help or suggestions greatly received!

Thanks