Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to know what formula to use for this hope someone can help
in cell A2 i have a percentage value. I want cell B2 to display a value of 1 or 0 1 if the value in cell A2 is above 10% or below -10% and 0 if the value in Cell A2 is between 10% and -10% hopefully this makes sense I have approximately 500 cells giving me a variance and at the moment i have to manually check them before adding them all up so any help would be much appreciated and would save me a lot of manual work |