User Help

IFS function in excel not able to work

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 […]