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

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

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

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

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

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

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