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=m If it's greater than .25 then it is also greater than -.25
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |