| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Linear Mode
