I am not sure what is the problem, either is syntax error, or data error. The data in 1st column F is all text. Some are in millions (with the word ‘M’ at the end) and some in thousands ((with the word ‘K’ at the end). I want to convert all to numbers and put […]

Categories

## IFS function in excel not able to work

- Post author By How To
- Post date June 1, 2020
- No Comments on IFS function in excel not able to work

- Tags "")*1000)` Please refer to the screenshot:, $m, 000 or 1, 000. And i put it in IFS function. The formulae seems to work for the texts that contain 'M', 000), 1000000, and multiply by 1, but not working for 'K'. I am unable to see why. My formulae for the first column as follows: `=IFS(FIND("M", either is syntax error, F2)>0, FIND("K", I am not sure what is the problem, I compare whether the end of the text is either 'M' or 'K' using FIND(), K, or data error. The data in 1st column F is all text. Some are in millions (with the word 'M' at the end) and some in thousands ((with the wo, SUBSTITUTE(F2, then i used SUBSTITUTE to remove the 'M' or 'K'