Forum Discussion
Help with Running a formula within a formula for multiple individual results
Ok, how best to explain my dilemma. I am trying to program a simulation of multiple events based on a couple of factors. Bear with me, and my Excel file is protected information so I can't share ...
Can't you use
=IF(B226=1,(IF($N$228=$R$223,RANDBETWEEN(1,20)+$C$223,
IF($B$223=$P$228,$Q$228,IF($B$223=$P$229,$Q$229,IF($B$223=$P$230,$Q$230,IF($B$223=$P$231,$Q$231)))))),"")