Compare the Cell between + or - value
 

Dear All,
Good evening, I need to compare(look up ) the value in cell A and cell B
(plus or minus of the value in cell A) and put the result in cell c "false "
or "true"

Ex :

Cell A Cell B Cell C
10 12 True

12 20 false

18 16 true

25 30 false


Please help me in this situation, we need to compare thousand of lines in
every day.

Thanks and Regards,
Vadivelan Adhimoolam.

Compare the Cell between + or - value
 

Dear All,
Good evening, I need to compare(look up ) the value in cell A and cell B
(plus or minus 2 of the value in cell A) and put the result in cell c
"false "
or "true"

Ex :

Cell A Cell B Cell C
10 12 True

12 20 false

18 16 true

25 30 false


Please help me in this situation, we need to compare thousand of lines in
every day.

Thanks and Regards,
Vadivelan Adhimoolam.


"Vadhimoo" wrote:

Dear All,
Good evening, I need to compare(look up ) the value in cell A and cell B
(plus or minus of the value in cell A) and put the result in cell c "false "
or "true"

Ex :

Cell A Cell B Cell C
10 12 True

12 20 false

18 16 true

25 30 false


Please help me in this situation, we need to compare thousand of lines in
every day.

Thanks and Regards,
Vadivelan Adhimoolam.

Compare the Cell between + or - value
 

It sounds like you need an IF:
=IF(OR(ABS(A2-B2)<=2,ABS(A2-B2)<=2),"True","False")


On May 23, 11:56 am, Vadhimoo
wrote:
Dear All,
Good evening, I need to compare(look up ) the value in cell A and cell B
(plus or minus 2 of the value in cell A) and put the result in cell c
"false "
or "true"

Ex :

Cell A Cell B Cell C
10 12 True

12 20 false

18 16 true

25 30 false

Please help me in this situation, we need to compare thousand of lines in
every day.

Thanks and Regards,
Vadivelan Adhimoolam.

"Vadhimoo" wrote:
Dear All,
Good evening, I need to compare(look up ) the value in cell A and cell B
(plus or minus of the value in cell A) and put the result in cell c "false "
or "true"

Ex :

Cell A Cell B Cell C
10 12 True

12 20 false

18 16 true

25 30 false

Please help me in this situation, we need to compare thousand of lines in
every day.

Thanks and Regards,
Vadivelan Adhimoolam.

Compare the Cell between + or - value
 

=if(abs(a1-b2)<=2,"True","False")
--
Wag more, bark less


"Vadhimoo" wrote:

Dear All,
Good evening, I need to compare(look up ) the value in cell A and cell B
(plus or minus of the value in cell A) and put the result in cell c "false "
or "true"

Ex :

Cell A Cell B Cell C
10 12 True

12 20 false

18 16 true

25 30 false


Please help me in this situation, we need to compare thousand of lines in
every day.

Thanks and Regards,
Vadivelan Adhimoolam.

Compare the Cell between + or - value
 

=ABS(A2-B2)<=2
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Vadhimoo"

wrote in message
Dear All,
Good evening, I need to compare(look up ) the value in cell A and cell B
(plus or minus of the value in cell A) and put the result in cell c "false "
or "true"
Ex :
Cell A Cell B Cell C
10 12 True

12 20 false

18 16 true

25 30 false
Please help me in this situation, we need to compare thousand of lines in
every day.
Thanks and Regards,
Vadivelan Adhimoolam.