Oct 11 2019 01:59 AM
Please help.
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;
=IF(G6>=6000,"£400","")
Oct 11 2019 02:04 AM
Oct 11 2019 02:10 AM
@PascalKTeam I have tried it both ways but even with just a number it will not display as a number that can be used in a later calculation.
I have done a workaround using the =VALUE but requires another cell to be used.
Oct 11 2019 02:15 AM
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.