Hello All,
I have to compare the values and using the result in Table tool for conditional formatting.
scenario - I have two columns as below
Col1 Col 2
A 100
B 60
C 40
Now I want to compare if the value of A = value of B + value of C the 1 else 0. How to write a formula for this.
Thanks in Advance
Solved! Go to Solution.
It works, thanks for the solution.
In Addition to the earlier scenario.
How to compare values of different rows.
Scenario
Col1 Col2
A 10
B 0
C 5
D 7
E 10
I have to compare the values of A and E, how to do it
Thanks in Advance.