An excel file wich alot of values.

i want that greater then 0.25=M and greater then -0.25=m

Hi, If cell A1 contains the value to be tested, this formula will return nothing "" if the value in A1 is -0.25 or less, it will return "m" if the value is greater than -0.25 up to 0.25 and if greater than 0.25 it will return "M".

=IF(A1>0.25,"M",IF(A1>-0.25,"m",""))Regards

re: i want that greater then 0.25=M and greater then -0.25=mIf it's greater than .25 then it is also greater than -.25

Ask Your Question

Weekly Poll