If you have a range of cells in different currencies, how do you do this with the IF Function:
If the cell contains "USD", then return the value of a certain cell.
It's not IF(A1="USD"....), what i want is IF(A1 contains "USD".........), but how do I specify "contains".
Thanks.
If the cell contains "USD", then return the value of a certain cell.
It's not IF(A1="USD"....), what i want is IF(A1 contains "USD".........), but how do I specify "contains".
Thanks.