Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Taking your post and expanding on it, this part :
If you can bear to hear the truth you've spoken
Twisted by knaves to make a trap for fools,
Or watch the things you gave your life to, broken,
And stoop and build 'em up with worn-out tools:
If you can make one heap of all your winnings
And risk it all on one turn of pitch-and-toss,
And lose, and start again at your beginnings
And never breath a word about your loss;
condenses to this:
=IF(Or(And(KnaveTwist=StrRev(Truth), 1 < 2), XL07 = TRUE), @IF(@RAND < 0.5, "", (@SUM(win,win2,win3))*2), …)
If you can bear to hear the truth you've spoken
Twisted by knaves to make a trap for fools,
Or watch the things you gave your life to, broken,
And stoop and build 'em up with worn-out tools:
If you can make one heap of all your winnings
And risk it all on one turn of pitch-and-toss,
And lose, and start again at your beginnings
And never breath a word about your loss;
condenses to this:
=IF(Or(And(KnaveTwist=StrRev(Truth), 1 < 2), XL07 = TRUE), @IF(@RAND < 0.5, "", (@SUM(win,win2,win3))*2), …)
