I would like the IF function to return a value in £'s which i can use for another SUM. However, i can only get a number in the cell which is not seen by any other calculations as a number. My formular is this;
First thing to do is to change the format of the said cell in to currency. Sometimes they are automatically set to Text if a currency sign is used. If changing to currency is not working then there can be some characters can be present in the values so you may need to use trim and clean formulas to remove these characters. If this works then you can copy this new column and paste is as values and delete the original column.