Assigning a value???
Posted by Brittany on July 27, 2001 3:27 PM
I could change columns B and C to an X vs P and B if formula would be easier to calculate..
There will never be a value in B and C at the same time nor a value in E and F at the same time...
P in Col B and X in Col E = 4 in Col D
P in Col B and X in Col F = 3 in Col D
B in Col C and X in Col E = 3 in Col D
B in Col C and X in Col F = 2 in Col D
Col B = If it contains P will have a value of 2
Col C = If it contains B will have a value of 1
Col D = Sum of B, C, E and F
Col E = If it contains X will have a value of 2
Col F = If it contains X will have a value of 1
Thank you!
Brittany
Posted by Aladin Akyurek on July 28, 2001 1:08 AM
Brittany,
In D2 enter the following Boolean formula and copy down as far as needed.
=(B2="P")*2+(F2="X")*1+(C2="B")*1+(E2="X")*2
Aladin
==================
