Excel formulla for greater than

March 31, 2010 at 21:39:45
Specs: Microsoft Excel
An excel file wich alot of values.
i want that greater then 0.25=M and greater then -0.25=m

See More: Excel formulla for greater than

Report •


#1
April 1, 2010 at 04:09:30
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


Report •

#2
April 1, 2010 at 05:43:07
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


Report •

Related Solutions


Ask Question