formula help
 

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

formula help
 

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

formula help
 

On Apr 24, 4:31*pm, 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

formula help
 

On Apr 24, 4:31*pm, 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

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


ed

formula help
 

On Apr 24, 8:19*pm, ed wrote:
On Apr 24, 4:31*pm, 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 -

Put the following formula in cell B2 =(or(A1<.1,A2.1)1,0)

ed

formula help
 

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

formula help
 

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