Femto_Engineer
2010-04-02, 01:36 AM
Hi all MS Excel Gurus,
My question may be simple enough but I was unable to find a solution to it online.
The problem is:
I have three columns e.g. A, B, C. The columns correspond to received signal strength of different cells at a point. What I would like to do is 'make another column D. Now at each row, I will check the columns A, B, C and see if all of them correspond to a specific value e.g.
A1=B1=C1= 2
If the above condition is true then I should have 1 at D1 otherwise 0.
please help
My question may be simple enough but I was unable to find a solution to it online.
The problem is:
I have three columns e.g. A, B, C. The columns correspond to received signal strength of different cells at a point. What I would like to do is 'make another column D. Now at each row, I will check the columns A, B, C and see if all of them correspond to a specific value e.g.
A1=B1=C1= 2
If the above condition is true then I should have 1 at D1 otherwise 0.
please help