Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check result if same as other cell on row
Hello:
Whats the shortest way to check with a formula if the result of the cell is the same of another cell on that same row? If I have in Cell A1 521, and in B1 634, and C1 878 and in D1 I have a formula which the reult will come out to 634, how can I check in D1 that if the result will be the same value like any other cell in Row 1, then the value in cell D1 should be 0, rather than 634? Thanks Art. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check result if same as other cell on row
Try this:
=IF(COUNTIF(A1:C1,your_formula),0,your_formula) -- Biff Microsoft Excel MVP "art" wrote in message ... Hello: Whats the shortest way to check with a formula if the result of the cell is the same of another cell on that same row? If I have in Cell A1 521, and in B1 634, and C1 878 and in D1 I have a formula which the reult will come out to 634, how can I check in D1 that if the result will be the same value like any other cell in Row 1, then the value in cell D1 should be 0, rather than 634? Thanks Art. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question to check the conditions and then print the result. | New Users to Excel | |||
check box checked - then a result to show in another cell???? | New Users to Excel | |||
Check if result is an integer? | Excel Worksheet Functions | |||
cell calculation check if result is negative and zero out if not l | Excel Worksheet Functions | |||
How do I check the conditions of 2 fields to return a result | Excel Discussion (Misc queries) |