IF function

Copper Contributor

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","")

 

 

4 Replies
Hi, probably better to not include "£" symbol into the formula but instead format the cell as currency. Check out this article to see how to do this: https://support.office.com/en-us/article/format-numbers-as-currency-0a03bb38-1a07-458d-9e30-2b54366b...

@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.

you should get rid of the "
=IF(G6>=6000,400,"")

@TheJackal72 

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.