Great god taught, and how to use function embodied in the subordinate conditions return different va-CodePudding

If 128=Monday, 64=Tuesday, 32=on Wednesday, Thursday 16=,=8 on Friday, 4=on Saturday, 2=on Tuesday, then B1=144, A1=Monday, Thursday, how to use the formula to reflect, please?

CodePudding user response:

Binary value bitwise, or use a custom formula?

CodePudding user response:

Excel?

CodePudding user response:

The

refer to the original poster gj? Response:

if=128 on Monday, 64=on Tuesday, 32=on Wednesday, Thursday 16=,=8 on Friday, 4=on Saturday, 2=on Tuesday, then B1=144, A1=Monday, Thursday, how to use the formula to reflect, please?

Problem condition not good ah,,,
144 can also is on Monday and Friday, Friday

CodePudding user response:

The

reference 3 floor SXZLC response:

Quote: refer to the original poster gj? Response:

If 128=Monday, 64=Tuesday, 32=on Wednesday, Thursday 16=,=8 on Friday, 4=on Saturday, 2=on Tuesday, then B1=144, A1=Monday, Thursday, how to use the formula to reflect, please?

Problem condition not good ah,,,
On Friday, 144 can also is on Monday and Friday

144 contains 128 on Monday and Thursday 16 (16 + 144=128
)

CodePudding user response:

refer to the second floor peter_zhhg6 response:

Excel?

yes

CodePudding user response:

reference 1/f, zara's reply:

turn binary bitwise values, or use a custom formula?

Excel formula