From: cufc1210 on 25 Apr 2010 12:53 Thanks for that Andre C much appreciated and will save me an awful lot of work, probably save my eyesite as well "Andre C" wrote: > In cell B2 have this formula =if(abs(a2)>10%,1,0) > Copy down as needed > > "cufc1210" wrote: > > > 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 From: ed on 26 Apr 2010 13:52 On Apr 25, 11:53 am, cufc1210 wrote:> Thanks for that Andre C much appreciated and will save me an awful lot of > work, probably save my eyesite as well > > > > "Andre C" wrote: > > In cell B2 have this formula    =if(abs(a2)>10%,1,0) > > Copy down as needed > > > "cufc1210" wrote: > > > > 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- Hide quoted text - > > - Show quoted text - My previous reply was in error. It should have been " Put the following formula in cell B2 =(OR(A2<.1,A2>.1)1,0) " ed First  |  Prev  |  Pages: 1 2 Prev: Is this possible?Next: Converting Baseball Innings when Summed