Today try to make some calculation sheets all worked well for me till i try 'k' and 'm' valued items. I got the warning the the 10.0 value was text and couldn't be multiplied. I made the m/k formula a little bit more ugly, but it will work now. =if(iferror(find("m";C3);false);VALUE(SUBSTITUTE(left(C3;find("m";C3)-1);".";","))*1000000; if(iferror(find("k";C3);false);VALUE(SUBSTITUTE(left(C3;find("k";C3)-1);".";","))*1000;VALUE(SUBSTITUTE(C3;",";"."))))