formula help

  • Thread starter Thread starter cufc1210
  • Start date Start date
C

cufc1210

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
 
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
Click to expand...
 
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
Click to expand...

Put the following formula in cell B2 then copy if down the column,
assuming your other test cells are in column B.


ed
 
Thanks for that Andre C much appreciated and will save me an awful lot of
work, probably save my eyesite as well
 
Thanks for that Andre C much appreciated and will save me an awful lot of
work, probably save my eyesite as well






- Show quoted text -
Click to expand...

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
 
Back
Top